AD 87-10-06 R1
Registered aircraft · 72,010
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:87-10-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
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:87-10-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1') 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.
N737AYMoeller Dakota J · West Point, IAN737BBHaughey Mathew · Celebration, FLN737BCN737bc LLC · Dover, DEN737BDMusic City Air LLC · Rogersville, ALN737BKDesert Sand Aircraft Leasing Co Inc · Rosharon, TXN737BTCharlie Lima 1 LLC · Jacksonville, FLN737BUAero Equities LLC · Ventura, CAN737CEScanlan Michael · Carmel Valley, CAN737CFZia Air 7cf LLC · Redwood City, CAN737CHCharlie Lima 1 LLC · Jacksonville, FLN737CKFreiberg Alan E · Mobile, ALN737CNSouthern Aircraft Consultancy Inc Trustee · Casper, WYN737CPFlight Exams Inc · Deland, FLN737CQDo Aviation LLC · Elgin, SCN737CVDeland Aviation LLC · Deland, FLN737CWWakefield Aviation LLC · Riverton, UTN737CXEb Flight Training LLC · Daytona Beach, FLN737CZMt Vernon Airport Authority · Mount Vernon, ILN737DASky II LLC · Lees Summit, MON737DBTidewater Technologies LLC · Wilmington, DEN737DCBirkenhead Judy · College Park, MDN737DDSorbi Aviation Inc · El Cajon, CAN737DESky Creation Inc · Torrance, CAN737DGEagle Aviation LLC · Spearfish, SDN737DJYoungs Farm Blue Mountain Ranch LLC · Paulina, ORN737DLRobertson Steven J Trustee · Escondido, CAN737DPAero Photo · Spicewood, TXN737DRVannote Eugene L · Belews Creek, NCN737DSEmpty Nest LLC · Glen Ellen, CAN737DTAdvance Aviation LLC · Mount Vernon, IAN737DVSuperior Flying Services LLC · Superior, WIN737DWMh Aviation Inc · Lancaster, CAN737DYAsset Flight LLC · Beaumont, TXN737EBVx Ventures LLC · Castle Rock, CON737ECBlock Craig L · Murrieta, CAN737EERising Wings Aviation Inc · Casper, WYN737EGWilson Scott A · Livingston, LAN737EHGiese Douglas S · San Angelo, TXN737EMPreston Richard R Trustee · Albuquerque, NMN737EPN737ep Partners LLC · Blue Jay, CAN737ESNovember Seven Echo Sierra LLC · Pineville, LAN737ETOptima Aviation LLC DBA · Lewisville, TXN737EWOklahoma Airmen Flying Club Inc · Jenks, OKN737FDMeadows Stone & Paving Inc · Gassaway, WVN737FFWorley Donald E Jr · Rocky Mount, VAN737FHEagle Simulator LLC · Lake Oswego, ORN737FJVero Technical Support Inc · Pensacola, FLN737FRShepard Christopher N · Westerville, OHN737FTIowa Lakes Community College · Estherville, IAN737FUWarren Darryl · Clinton, AR
Back to AD 87-10-06 R1