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.
N695ATL And P Air 2 LLC · Lees Summit, MON695CFN695cf LLC · Richmond, VAN695PGTurcaian Export Services Inc · ProvidencialsN695TClay Kennamer Livestock Farms LLC · Hollywood, ALN695TJUhb Aircraft LLC · Murray, UTFirst renewal noticeN6967NSand Creek Oil & Gas Inc · Edmond, OKN6969YTorres Charles O · Riverside, CAN696BTSanta Anita Inc · Dallas, TXN696CCMchale Robert S · Holland Patent, NYN696DTRastavan David DBA · La Habra, CAN696KBWindsock Aviation LLC · Oak Hill, VAN696PGCirrus Sr22 3606 Inc Trustee · Wilmington, DEN696PMSindicich Michael · San Francisco, CAN696RSSomax LLC · Dudley, MON6972NEnns Robert B · Cayucos, CAN6976NCenturion Capital Partners LLC · Blue Ash, OHN6977BCollins Kevin T · Roseville, CAN6979NArango Jorge · Mcallen, TXN697CMrc Aviation LLC · Columbia, TNN697CBPaul L W Smith Inc · Kingston, GAN697SRSouthern Aircraft Consultancy Inc Trustee · Casper, WYN6980MPetumenos Timothy James · Anchorage, AKN698CMuehlstein Charles W · Stamford, TXN698ESSund Lloyd · Kramer, NDN698MXDauphin Island Air LLC · Ladue, MON6993NSp Aircraft LLC · Moscow, IDN69983Ruble Air LLC · Mechanicsburg, PAN699BBProfi-Vision Inc · Fogelsville, PAN699CDFaridev LLC · White Plains, NYN699EEMathes Jay B · Ridgecrest, CAN699PFN699pf LLC · Haymarket, VAN699PKAir 1111 LLC · San Diego, CAN699PSMcmillen Yachts Inc · Newport, RIN699TGTkg Aviation Inc · Port Orange, FLN69CLTspy Services Inc · Nicholasville, KYN69FGTide Sr22t Gts LLC · Clearwater, FLN69GDBonanza Five Flying Club Inc · Roswell, GAN69HEHoney Badger Aviation LLC · Texarkana, ARN69LEEle Motorsports LLC · Dover, DEN69MZHall John · Litchfield Park, AZN69PBAerocraft Papa Bravo LLC · Hallandale, FLN69PGBaird Mark · Fort Jones, CAN69PKBiofusion LLC · Fort Smith, ARN69WAKeystone Aerial Surveys Inc · Philadelphia, PAN69YKMetal Wholesale LLC · Bloomfield, IAN69ZAMoleno Capital LLC · Dallas, TXN6APAirtrust LLC - 8 - Series 8 Trustee · Sheridan, WYN6BGMollica Air LLC · North Andover, MAN6BYDac Aero LLC · Jacksonville, FLN6BZN6bz LLC · Lewes, DE
Back to AD 2012-10-13