AD 87-20-03 R2
Registered aircraft · 54,015
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-20-03-R2')
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-20-03-R2')
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-20-03-R2') 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-20-03-R2') 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.
N9743HReese Jeffrey D · Portland, ORN97443Miller Charles L Jr · Eunice, LAN97446Mpm Wizard Enterprise LLC · Hawthorne, CAFirst renewal noticeN9744AKahrs Andrew J · Bainbridge Island, WAN97452Taylor Michael Riding · Friday Harbor, WAFirst renewal noticeN97453Stofer William B · Warsaw, INN97456Harrington Co · Butte, MTN97459Christiansen Aviation LLC · Wilmington, DEN9745TOwens Edward W · Raymore, MON97465Civil Air Patrol Inc · Maxwell Afb, ALN97467Kg Rentals LLC · Edmond, OKN97469Wooten James E · Avinger, TXN9746APetey LLC · Bozeman, MTN9746BRegistration Pending · Middletown, DERegistration pendingN9746CBas Part Sales LLC · Greeley, CON9746XAgent West Insurance Inc · Hurricane, UTN9746YAircraft Holding Solutions LLC Trustee · Newark, DEN9747GPavlu Aerial Spraying LLC · Ness City, KSN9747TMapes James R · Ellensburg, WAN97485Strong Neil E · Pittsburg, TXN97487Bruns Gregg R · West Chester, OHN97489Neron II LLC · Lewes, DEN9748AJuhl Amanda · Centennial, CON9748GKlamar Spraying Inc · Gatzke, MNN9748ZKerr Kenneth E · Bakersfield, CAN9749BLee Norman S · Green Valley, AZN9749G3 B Farms Inc · Pinetown, NCFirst renewal noticeN9749XNeal Daniel A · Winchester, TNN974CAFranks Gary W · Bolivar, MON974RCRafael Cisneros LLC · Wilmington, DEN974SFAerospace Trust Management LLC Trustee · Wilmington, DEN97503Mercury International LLC · Cheyenne, WYN97508Sale Reported · Hurricane, WVSale reportedN9750GGee Richard L · Seattle, WAN9750LLouisiana Department Of Public Safety · Baton Rouge, LAN9750QPurdy Adrian · Missouri City, TXN97513Registration Pending · Colona, ILRegistration pendingN9751APerla Guido F · Vashon, WAN9751BDoyle Kevin M · Kenai, AKN9751GJanes John L Jr · Anchorage, AKN9751TAbles Marlan L · Carthage, ARN97523Rwp LLC · Bloomington, INN97528Sky Warrior Flight Training Inc · Pensacola, FLN9752BUniversity Of Alaska Anchorage · Anchorage, AKN9752XBirdman Aviation LLC · Indianapolis, INN9752ZRocky Pointe Logistics LLC · Hayden, IDN97533Associated Pilots Inc · Winchester, MAN9753AFowler Flyers Inc · Fowler, CON9753TCowan Ronnie C · Glasgow, KYN9753VBellamy Mark A · Freeville, NY
Back to AD 87-20-03 R2