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.
N8910BStone Tim · Siloam Springs, ARN8910TSaa Enrique A · Lubbock, TXN8910XElardi Frank Paul · Upland, CAN89114Drop Table Airplanes LLC · San Anselmo, CAN8911BPeterson Clifford H · Old Town, MEN8911SPriglmeier Mark L · Deerwood, MNN8911VHorizon Dreams LLC · Homer, GAN8912VRoper Jeff A · Corralitos, CAN8912XAman Douglas A · Fairfield, ILN89132Affiliated Air Services Inc · Southampton, NJN8913VI'Ll Fly Away LLC · Florence, SCN8914SCarroll Louis · Perris, CAN8914XHawkins William A · Euless, TXN89159Napiecek Sarah · Kyle, TXN8915GFerdon Richard P Trustee · Fort Mohave, AZN8916BSanborn George A Sr · Culver, ORN8916GSorenson Robert H · Forsyth, MTN8916VTaylor William W Jr · Hudson Oaks, TXN8917BTederman Terri Lynn · Auburn, WAN8917XCleveland William B III · Canal Fulton, OHN89186Hangar 47 Aviation LLC · Midvale, UTN8918TAirtime LLC · Wilmington, DEN8918XRtillery Services LLC · Holdrege, NEN89192Stone Christopher B · High Point, NCN89197Campbell Michael R · Aurora, NEN8919TUllmann Wilmer R · Fairview, TXN8919VChristiansen John · Vicksburg, MIN891SPSkydive Pennsylvania · Mercer, PAN891SROmalley Benjamin P · River Falls, WIN8920SWefald Richard I · Jordan, MNN89215Delgado Ruben E · San Antonio, TXN8921TRoberts Marty · Mount Hermon, LAN8921VN2827n LLC · Pembroke Pines, FLN89226Hillsboro Aero Academy LLC · Hillsboro, ORN8922VTampa Bay Aviation Inc · Clearwater, FLN8923SHuang Chen · Chino Hills, CAN8923VMollica Richard Anthony · Oxnard, CAN8924VDupree Johnny · Crossett, ARN8924XPrevo Jerry L · Anchorage, AKN8925XMuetterties Eric Joseph · Dublin, CAN8926BEmery Marilyn L · Randle, WAN8926SRichardson Gordon P · Polson, MTN8926TBowlin George E · Roanoke, INN8926VCareer Flight Training And Aircraft Rental LLC · Naples, FLN8926XNelson Bobby E · Naples, FLN89273Anderson Ben H · Fort Smith, ARN8927BSale Reported · Crystal, MNSale reportedN8927TRockfish Ventures LLC · Wilmington, NCN8927URoberts Colton C · Bluebell, UTN8927VTropical Aviation LLC · Gulf Shores, AL
Back to AD 87-20-03 R2