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.
N92471Shoemaker Floyd · Oneida, TNN92472Boyle Neal · Beaver Island, MIN92479Hill Top Aviation LLC · Humboldt, SDN92481Barraza Construction LLC · Saint Joseph, LAN92486Big E LLC · Lemoore, CAN9248BJackalope Aviation LLC · Bellingham, WAN9248CRegistered aircraftN9248XPadua Corp · Wilmington, DEN92492Meger Daniel F · Lincolnton, NCN92495Welborn Mark Grant · Boonville, NCN9249AZabowski Alan G · Belvidere, NJN9249BCoull Jennifer · Easton, PAN9249HGencur Paul A · Hudson, OHN9249RGreat Plains Applications LLC · Slayton, MNN924ASA2g International LLC · San Juan Capo, CAN924MCJ Airco LLC · Nashville, TNN92503Harper Bryan K · Junction City, ORN9250XRapchak Barbara A · Batavia, ILN92519Flory Air LLC · Culdesac, IDN9251AMills Don T · Fairfield, CAN9251BBurke Charles M · Ocala, FLFirst renewal noticeN9251UCarpenter James M · Marion, ARN9251XWhite Ronald V · Overgaard, AZN92520Heartland Air Services LLC · Wilmington, DEN9252BSwain Raymond B · Mansfield, TXN9252CBartels Aaron J · Brenham, TXN9252GEmbry Aero Ltd · Greenville, ILN9252HStratus Aviation LLC DBA · Vacaville, CAN9252RBank Of Utah Trustee · Salt Lake City, UTN9252UHoffman William C · Rostraver Township, PAN92532Jones Timothy D · Cooper, TXN92534Courtney Joseph D · Livingston, LAN9253GSteiner Ivy C · Fairhope, ALN9253RDr Equipment LLC · Ackerly, TXN9253TMichael J Kraynick Pllc · Hailey, IDN92541Larson Alexis Kae · Bismarck, NDN92542Timing Building LLC · Wilmington, DEN92546Maracek Thomas · Middletown, CAN92548Pulliam Richard W · Henryetta, OKN9254AHattell George Curtis · Olympia, WAN9254BMcdonald Daniel R · Las Vegas, NVN9254GStowe Henry L · Covington, GAN9254HShipley Donald E · Alpine, TXN9254TLuper Gary M · Anchorage, AKN92551Brazos Valley Flyers LLC · College Station, TXN92554Kortsen & Associates LLC · Flagstaff, AZN92557Soto Naomi · Ocala, FLN92559Olmo William J · Priest Lake, IDN9255TShepp Carl R Jr · Florence, MTN92567Registration Pending · Orlando, FLRegistration pending
Back to AD 87-20-03 R2