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.
N73927Abcd Ventures LLC · Ada, OKN73928Air Peanut Ltd · Wilmington, DEN73929Jprg Aviation Inc · Orlando, FLN7392J33 Global LLC · Potomac Falls, VAN7392PGray Matthew R · Haymarket, VAN7392VBrown Mill Ranch LLC · Lamar, CON73930Bunke Paul R Trustee · Harrison, OHN73934Hanson Alexander P · Bremerton, WAN73938Preston Richard R Trustee · Albuquerque, NMN7393GBlue Wings LLC · Brecksville, OHN7393JSale Reported · Tyler, TXSale reportedN7393ZDrennan Monte D · Caddo, OKN73946Carastro Enterprises LLC · Montgomery, ALN7394PWhittle Mark A · Crestview, FLN7395DAviation Management Group LLC · Endicott, NYN7395GBrewer James · Myakka City, FLN7395JOhm Aviation LLC · Wmca, NVN7395PGroux Jeffrey S · Rome, GAN7395WHuckfeldt Owen D · Alliance, NEN7395XBrl Air LLC · Onsted, MIN73964Coachron Investments LLC · Grosse Ile, MIN7396JBurns Preston T · Spruce Pine, ALN7396WN7396w LLC · Coeymans Hollow, NYN7396YAllen Charles M · Puryear, TNN73977Bfl Aviation LLC · Bakersfield, CAN7397GMarkowitz Edwin P · Luray, VAN7397JJmk Repair · Lone Oak, TXN7398Weston Weed Control LLC · Weston, WYN73981Gagnon Michael J · Merrimack, NHN7398JGreat Lakes Aviation Services LLC · Kimball, MIN7398WJil Aviation Inc · La Coste, TXN7399JGordon Jacob M · Tega Cay, SCN7399PPache Keith M · Montgomery, TXN7399WI Was Inverted LLC · Fort Myers, FLN739ADSeven Three Nine Alpha Delta Club Inc · Memphis, TNFirst renewal noticeN739AFSilver Isaac M · Satellite Beach, FLN739AGS O W Aviation LLC · Crystal River, FLN739AJAviation Adventures LLC · Billings, MTN739AKChen Wu · West Windsor, NJN739AMBartels Michael · San Antonio, TXN739APMilwaukee Aero LLC · Milwaukee, WIN739AQAzure Mahpiya LLC · Dublin, CAN739ASDel Martin Lp · Spring, TXN739ATSocal Aviation Inc · Chino, CAN739AVMk914 Aviation LLC · Boynton Beach, FLN739AWOsborn Lawanda H · Weatherford, TXN739BCSecond Wind Aviation Corp · Friday Harbor, WAN739BEFtg Leasing LLC · Watkins, COFirst renewal noticeN739BJDuffys Aircraft Sales & Leasing Inc · Neillsville, WIN739BKSundown Robert W · Bethel, AK
Back to AD 87-10-06 R1