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.
N9476TRegistered aircraftSale reportedN9476USantos Enderson Rafael Teixeira Dos · Aledo, TXN9476XMcdonald Air LLC · Indianapolis, INN94772Kamal Rafi · Mountain View, CAN9477BMilson Stuart A · Midlothian, TXN9477LSlipstream Aviation LLC · Carrollton, GAN9477URegistration Pending · Delta Junction, AKRegistration pendingN9478EColeman Richard · Menominee, MIN9478GExecutive Security Solutions LLC · Moody, ALN9478T4cl Inc · Wilmington, DEN94790Kingsky Flight Academy LLC · Lakeland, FLN9479GCox Ramona T · Manhattan Beach, CAN947ETGranite State Aerial Topography LLC · Wolfeboro, NHN947SFSnohomish Flying Service Inc · Snohomish, WAN94800Trick Aviation LLC · Kalispell, MTN9480BAlexis Aviation LLC · Greenwell Springs, LAN9480DKent State University · Stow, OHN9480EMoyer Aviation Inc · Tobyhanna, PAN9480HMoynihan Patrick J · Lakeville, MNN9480RWestern Montana Orthopaedic LLC · Missoula, MTN9480UColeman Stephen A · Wakefield, RIN94810Kaski Brian · Battle Ground, WAN94812James Hamilton Construction Co · Silver City, NMN9481BPueppke Clinton · Ayr, NDN9481CWhitby Christopher W · Prescott, AZN9481DBoemig Madison K · Dalton, NHN9481UParnell Jr Jerry · Panama City, FLN9481X2310 Woodcrest LLC · Freeland, PAN94822Elon Aviation LLC · Burlington, NCN9482MWestwind Aviation Inc · Phoenix, AZN9482RWindy Lane Farms Transport LLC · Mulberry, INN9482UClark Josh D · Morehead, KYN94837Leyser Joshua F C · Tega Cay, SCN9483HDelbrocco Christopher A · Waitsfield, VTN9483YSioux Falls Technology LLC · Sioux Falls, SDN9484CKnowles Jayson C · Winter Harbor, MEN9484HN9484h LLC · Wheeling, ILN9484XD&J Air Adventures Inc · Koloa, HIN94853Middle Georgia Aviation Services LLC · Warner Robins, GAN94854Sutliff John K · Walla Walla, WAN9485BLuggar Michael D · Leonard, MNFirst renewal noticeN9485RStevenson Flying Service LLC · Selden, KSN9485XBruckman Monty D · Edgewood, NMN9486BMccoy Robert P · Fairbanks, AKN9486GAndrew Odean T · Willow, AKN9486HStegehuis Richard L · Helenville, WIN9486RAnderson Aerial Spraying Serv Inc · Canby, MNN9486XSchilling Aviation Services LLC · Salina, KSN94872Weber Brian T · Hastings, MNN9487BFord Christian G · Pasco, WA
Back to AD 87-20-03 R2