AD 98-21-21 R1
Registered aircraft · 85,612
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:98-21-21-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1')
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:98-21-21-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1') 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.
N2692ROliver Craig J · Orion, MIN2692TWingsleasing LLC · Wichita, KSN2693DBarron Dillon L · Perry, MON2693KKelman Naomi · Nashville, TNN2693R15 Rides LLC · Manteo, NCN2693UBolden Myles · Plumas Lake, CAN2694DDagenhart Jason F · Anchor Point, AKN2694GInspec Aviation Inc · Schwenksville, PAN2694QMiller William A Jr · Okeechobee, FLN2694TStubby Wings LLC · Eden Prairie, MNN2694WDickerson Steven Micheal · Tipp City, OHN2695CNovak Peter A · Barrington, ILN2695DRoss David · Chestertown, MDN2695GBackcountry Guys LLC · Prescott, AZN2695LHindberg Jacob W · Fisher, MNN2695QKirbco Aviation LLC · Doniphan, MON2695RAccardo Paul A · Zwolle, LAN2695TJean-Baptiste Joseph C Sr · Brockton, MAN2696CUnited States Air Force · Peterson Afb, CON2696DWotring Samuel Daniel II · Mount Pleasant, TXN2696LPark Rapids Avionics Inc · Park Rapids, MNN2696QKlauber Gerald · Lake City, FLN2696RBowen Diane M · Newbury, MAN2696TRsp Aero LLC · Griffin, GAN2696VHall Cody G · Coeur D Alene, IDN2696WButler Collin · Danvers, MAN2696YD'Anna Michael Joseph · Durango, CON2697DSalinas Julius T · Esko, MNN2697KPrince John C III · Frierson, LAN2697MCmp Aviation LLC · Williamsville, MON2697RMaring Matthew D · Westley, CAN2697UOharra Robert J · Buckley, WAN2698DGumley Andrew · Wasilla, AKN2698GPeterson Floyd M · Lago Vista, TXN2698MBearce Larry James Jr · Solon, IAN2698QButler John L · Omak, WAN2698RWeishaupt Louis R · Mackinaw, ILN2698WLivesay Wallace · Friendswood, TXN2699FRegistration Pending · Jonesboro, ARRegistration pendingN2699L98x LLC · Caddo Mills, TXN2699UHogue Richard L · Dos Palos, CAN2699WKingman Connor Joseph · Lemoore, CAN2699XAir Controls Billings Inc · Billings, MTN269BACorporate Aviation Center LLC · Wilmington, DEN269BJN2893e LLC · Reno, NVN269CJLarson Martin B · Rapid City, SDN269DXPiper Aircraft Inc · Vero Beach, FLN269EAAviar Io LLC · Parker, TXN269KMParagon Airplane Leasing Co · Fort Myers, FLN269KTJfa Aviation Group LLC · Pompano Beach, FL
Back to AD 98-21-21 R1