AD 2012-10-13
Registered aircraft · 13,306
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N4870CHoffman Bertha M · Bethel, AKN4872KMike Papa LLC · Newton, KSN4875KHolland Karey Lynn · North Plains, ORN4876YCarson Engineering And Manufacturing Inc · Springdale, ARN4878Y182b LLC · La Plata, NMN487KMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN487SRArmins Properties LLC · Waterloo, IAN4887ZJav Air Services LLC · Anchorage, AKN4888CGoflight Inc · Birmingham, MIN488AJTm Helicopter Leasing LLC · Wilmington, DEN488BWBenchmark Air LLC · Jasper, INN488GTAngels Envy LLC · Austin, TXN488RHI F Rooks & Associates LLC · Memphis, TNN488SSale Reported · Friday Harbor, WASale reported, pending cancellationN488SJDeans Casing Service Inc · Holdenville, OKFirst renewal noticeN4895YKeating George W · Fayetteville, ARN4896KBraxtal LLC · Kingfisher, OKN4898CPalo Aerocraft Inc · Salem, VAN489CDFrg Aircraft Partnership LLC · Barefoot Beach, FLN489CPGregory L Wilkett · Piketon, OHN489SRN489sr Corp Trustee · Wilmington, DEN48AMGwc Air LLC · Madison, ALN48BEMy Aeroplane Company LLC · Bozeman, MTN48DBRegistration Pending · Short Hills, NJRegistration pendingN48KLMills Kenneth J · Fort Mill, SCN48LPEros Aviation Inc · Boston, MAN48MDN48md LLC · Hillsboro, ORN48PDCrown Of Texas Ventures LLC · Panhandle, TXN48RBRb Aviation Inc Trustee · Wilmington, DEN48RCMonson Horizon Inc · Reynolds, ILN48REMountain Tide LLC · North Bend, ORN48TIndian Springs Cattle Co Ltd · Wilmington, DEN48VAGeiser Corbin · Little Elm, TXN48WCBaron Acquisition LLC · Wayne, PAN4904N4904 LLC · Lithia, FLN4905CAnacapa Capital LLC · Fresno, CAN4909YFremont Airways LLC · Riverton, WYN490KMRasf414 LLC · Hallandale Beach, FLN490MLegacy Ofs Construction LLC · Stillwater, OKN490MMZenith Aviation LLC · Myrtle Beach, SCN490PDBrivana LLC · Sandy, UTN490SRSki Town Transport LLC · Jackson, WYN4911JDarter Lloyd R · Mountain Grove, MON4913JPassmore Stephen B DBA · Lacrosse, WAN4918UMission Aviation Fellowship · Nampa, IDN491ACEw Pegasus LLC · Walnut Creek, CAN491CJAero Beaver LLC · Kansas City, MON491SGryphon Ventures LLC · Apollo Beach, FLN491WMRenlim Aviation LLC · Brookhaven, GAN4922YHowey Aviation LLC · Woodhaven, MI
Back to AD 2012-10-13