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.
N9266XWeichert Robert S · Parker, CON9266ZR M B G Inc · Winnsboro, LAN92675Miller Saima A · Kodiak, AKN92677Burriss James E · Piedmont, SCN9267ABrown Craig A · Airway Heights, WAN9267GWaypoint Financial Services LLC · Raiford, FLN9267TDeeds Andy · Larkspur, COFirst renewal noticeN9267UDavis Andrew P · Leominster, MAN92680E & T Research And Development LLC · Sanford, NCN9268UIbrahim Motaz · Goodyear, AZN92690Nelson Richard B · San Mateo, FLN92691Registration Pending · Lebanon, TNRegistration pendingN9269ABriggs Aviation LLC · Virginia Beach, VAN9269BHaataja Charles M · Two Rivers, WIN9269HLargen Gregory K · Benton, KSN9269TAlsworth Leon R · Port Alsworth, AKN9269UDennis Matthew C · Transylvania, LAN926CSHardee Philip S · Florence, SCN926HMWestern Enterprise LLC · Pueblo, CON926LTHall Richard M · Scotland, SDN926MNPtw Consulting LLC · Atlanta, GAN92701Kyllo Jeffrey K · Larimore, NDN92704Gull Wing Flight LLC · Pt Pleas Bch, NJN92707Farquharson John L · Goldsby, OKN9270GFrye Warren S · Galax, VAN9270UYoung Orvel W · Maineville, OHN9270XCastle Rock Services LLC · Helena, MTN92711Intergard R&D LLC · Miami, FLN92712Pfister Michael J · Roanoke, ILN9271CSowder Douglas A · Spokane, WAN9271RUpwind Aviation LLC · Mitchell, SDN9271UWallis Bruce W · Kingwood, TXN92720Registration Pending · Champaign, ILRegistration pendingN92722Bryant David A · Walhalla, SCN92725Tucker Kyler T · Cypress, TXN92726Gray Stanley Paul Jr · Temecula, CAN9272BGyhra Bradley · Phenix City, ALN9272GSena James H · Edmond, OKN9272HBlackbird 71 LLC · Rockford, ILN9272RFarrow Sammie N Jr · Cordele, GAN9272TAkers Dana M · Kingston, NHN92739Mcmillin Michael C · Des Moines, IAN9273GPlisko Aviation LLC · Beaufort, NCN92746Hansen Barbara · Armstrong, IAN92747Wiles Donald · Shrewsbury, MAN9274AOshinuga Anthony · Valley Center, CAN9274HWings Over Texas Holdings LLC · Denton, TXN9274XGawlik Leslie W · Reisterstown, MDN9274ZIsham Shane A · Wichita, KSN92750Rauton Ken · Temecula, CA
Back to AD 87-20-03 R2