AD 2016-08-18
Registered aircraft · 399
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:2016-08-18')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-08-18')
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:2016-08-18') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-08-18') 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.
N4105DGrant Aviation Inc · Anchorage, AKFirst renewal noticeN4106FRocket Air Charter LLC · Melbourne, FLN4107QGrant Aviation Inc · Anchorage, AKN4108PN4455b LLC · Pompano, FLN41101Mcgregor Daniel A · Denali National Pk, AKN4112DYr-Aircraft Leasing LLC · Bethel, AKN4112EYr-Aircraft Leasing LLC · Bethel, AKN4112KGriffin Robert G Trustee · Anchorage, AKN41142Waters Agricultural Laboratories Inc · Camilla, GAN4114PChieftain 4114p LLC · Lewes, DEN41164Mike Jones Aircraft Sales Inc · Murfreesboro, TNN41166Moyer Aviation Inc · Tobyhanna, PAN4117ZC And R Hospitality LLC · Burkeville, TXN41189Yr-Aircraft Leasing LLC · Bethel, AKN4118B4118b Leasing LLC · Hallandale Beach, FLN4118GYr-Aircraft Leasing LLC · Bethel, AKN411USUnited States Air Force · Hanscom Afb, MAN422WBHbk LLC · Lynden, WAN426SSale Reported · Kotzebue, AKSale reportedN42HDMsm42h LLC · Jericho, NYN42HTP&M Partners LLC · Sumter, SCN42MHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN42RCRci Air Inc · Bridgeport, CTN42WPAir Arctic Inc · Fairbanks, AKN42YCApa Aviation LLC · Gainesville, FLN4301C70 North LLC · Anchorage, AKN437CBCsc Delaware Trust Co Trustee · Wilmington, DEN440APValiair Lc Owner Trustee · Casper, WYN4434DAir Arctic Inc · Fairbanks, AKN443MCFnnuts LLC · West Hazleton, PAN44ACFox Aircraft LLC · Bethel, AKN44GRFlying High LLC · Plainfield, ILN45002New England Aviation Air Charters LLC · Plainville, CTN45014Marc Inc · Bolton, MSN4501B70 North LLC · Anchorage, AKN45052Talkeetna Aero Services Inc · Anchorage, AKN450KCCharles City Aeronautics Inc · Charles City, IAN462DHFly Live Charter Inc · Fort Lauderdale, FLN46FAFox Aircraft LLC · Bethel, AKN46MYBeach Air LLC · Boynton Beach, FLN4910Vizas Global LLC · Grosse Pointe Park, MIN500HRDese Enterprises LLC · Huntsville, ALN500KPPung Michael W DBA · Alma, MIN50PSExecutive Airshares LLC · St Thomas, VIN515LGN515lg Holding Inc · Wilmington, DEN51KMBaker Leasing LLC · Kotzebue, AKN524ERGrant Aviation Inc · Anchorage, AKN530JBAir Transport Services Inc · Tarpon Springs, FLN543133seaslal LLC · Lakeland, FLN543JCBritshaw LLC · Lansdale, PA
Back to AD 2016-08-18