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.
N9916ZWings Of Wisconsin LLC · New Richmond, WIN99171Airlake Aero Inc · Lakeville, MNN9917BVisscher Ty · Santa Rosa, CAN9917ESopwith Camel Flying Club LLC · Salt Lake City, UTN9917NThunderbird LLC · Tacoma, WAN9917QStill Flying LLC · Gibsland, LAN9918EByrne Evan A · Mountain Lake Park, MDN9918NCalef Jere R Trustee · Mojave, CAN9918QCerqueira Luiz Fernando · Orem, UTN9918VGray Paul W · Eads, TNN9919BPlane Fun Inc Tr Trustee · Snellville, GAN9919EN9919e LLC · Rio Vista, TXN9919QBlomstrom Andrew R · Oregon, WIN991DMAircraft Registration Inc Trustee · KematenN991JWYochheim Brett · Zephyr Cove, NVN991NADatkuliak Michael C · Beallsville, OHN99204Clayburn Billy G · Yelm, WAN9920BSchultz Robert G · Baker, FLN9920VSkywarrior Flight Training Inc · Pensacola, FLN9920XPayne Ronald J II · Wasilla, AKN9921AAllen Air Ltd · Wray, CON9921EBigelow Jason A · Woodstock, ILN9921HDirodio Joseph · Ocala, FLN9921NHauxwell Bryan · Mccook, NEN9921XWinslow William G Jr · Show Low, AZN9922AWilliamson Cordy M · Darlington, SCN9922BStix David Jr · Fernley, NVN9922GAguilar William A · Puyallup, WAN9922NRobert N Shadduck LLC · Boulder, MTN9922XDooleys LLC · Glendale, AZN9922YInfinite Wings LLC · Henderson, NVN9923BFurtak Stephen A · San Diego, CAN9923EBulloch Troy P · Cedar City, UTN9923NMontana Capital Holdings LLC · Missoula, MTN9923TPrevo Jerry L · Anchorage, AKN9923VFive Pines Aviation LLC · Casper, WYN9923YPostupack Peter Jr · New Cumberland, PAN9923ZChena River Aviation Inc · Fairbanks, AKN99243Wings Over Texas Holdings LLC · Denton, TXN9924AAbner Cody J · Cleburne, TXN9924BNatre Air II LLC · Tipton, INN9924NMulcaire Jess · Camp Verde, AZN9924QMy Way Aviation LLC · Weston, FLN9924RInzer James Clarence IV · Baton Rouge, LAN9924TBlue Skies Aviation LLC · Wall, SDN9924VEdwards Kevin M · Grass Valley, CAN99253Mitiguy Aviation LLC · Stow, MAN9925BMartell Summer · Port Townsend, WAN9925EMeredith Dean J · Boynton Beach, FLN9925GPetecraft Aviation Services Inc · Plains, GA
Back to AD 87-20-03 R2