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.
N92405Burgess Brian Keith · Arnoldsville, GAN92406Anderson George C · Centerville, UTN9240CMcbeth Seth C · South Salt Lake, UTN9240HPropability One LLC · Daytona Beach, FLN9240RAir Dakota Flite · Hettinger, NDN9240XN9240x LLC · Martinsville, INN92415Registered aircraftN92416Fly Guys LLC · Olympia, WAFirst renewal noticeN92419N92419 LLC · Manteo, NCN9241CBaranek Brian Patrick · Nikiski, AKN92422Mack Nester R · Utopia, TXN92424Christiansen Cortland · Bakersfield, CAN92428Woodall Richard J · Yakima, WAN9242ARobinson William A · Franklin, TNN9242GJones Reginald L · Baton Rouge, LAN9242HRoland Aviation LLC · Gualala, CAN9242RAir Dakota Flite Inc · Hettinger, NDN9242ULiggett Garrett C · Eminence, MON9242XB Roberts Aviation LLC · Clovis, CAN92433Vandervis Inc · Tulare, CAN9243FCig Aviation LLC · Littleton, CON9243HSeward Air Taxi LLC · Seward, AKN9243RC & L Holzwarth Inc · Virden, ILN9243XSchoo Peter L · Lewiston, IDN92445Pureflight Aviation Training LLC · Newberg, ORN92447American Patrols Inc · Midland, TXN92448Eckholt John · Forest Grove, ORN9244AKauffman Forrest J · Coolidge, AZN9244GTrover Nicholas · Chico, CAN9244HCoachron Investments LLC · Grosse Ile, MIN9244UCairo Flying Club Inc · Cairo, ILN92452Meredith Judyann Cote · Lexington, KYN92456Watt Robert B · Mount Vernon, ORN92458Selby James T · Valley Center, CAN92459Warren Ronald Mark · Elizabeth City, NCN9245BHitt Lonnie D · Gatesville, TXN9245GHerb Liverett Companies Inc · Rio Linda, CAN9245TCook Erik C · Redmond, ORN9245UTaylor James R · Murfreesboro, TNN9245XLeupp John R · Taylors, SCN92460Wings 182 LLC · Genoa, NVN92461Flying Six Inc · Lander, WYN92463Sopatyk Brian D · Boise, IDN92464Tuschka Ted H · Donnelly, IDN92466Pierce Bradley D · Waco, TXN92467Jacobsen Thomas R · Auburn, CAN9246CReynolds Cody P · Sun City, CAN9246NWestways Aviation LLC · El Cajon, CAN9246UArtemis Aviation Group LLC · Kalispell, MTN9246XGrodi Leslie A · Monroe, MI
Back to AD 87-20-03 R2