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.
N2905ECappadona Roy · Iliamna, AKN2905LSteel Alan P · Odessa, TXN2905RKlassen Thomas · Corpus Christi, TXN2905UKear Edward B · Bonita Springs, FLN29061Swalling Frederick M · Anchorage, AKN29062Jackson Stephen D · Pennsboro, WVN29068Jd Flying LLC · Bellingham, WAN2906CNewman Dan A · Oak View, CAN2906DKennedy Ken · Lubbock, TXN2906LHogue Aviation LLC · Dover, PAN2906QCage James D · Muleshoe, TXN2906ULynch Lawrence C · Ladson, SCN29070Buzick Carey B · Fargo, NDN2907BPowell Gregory S · Paso Robles, CAN2907CPiedmont Southern Associates Inc · Clayton, GAN2907DSandhu Tejpal · Southlake, TXN2907QTweto Matthew E · Montgomery, TXN2907RFricks Cline Thomas Jr · Toccoa, GAN2907UServer William F · Sterling, MIN29084D E C Holdings · Hansen, IDN2908CWilliams Daniel P · Afton, WYN2908FCooprider Lee W Trustee · Littleton, MAN2908LGurney Stephen E · Niceville, FLN2908XArtsplane LLC · Parker, TXN2908YAnco Air Inc · Weston, FLN29098Gill Stuart W Jr · Kingsport, TNN2909ARasor William E · Brookville, OHN2909BIsland Hoppers Inc · Glenridge, NJN2909CHall Michael A · Spirit Lake, IDN2909DPainter Kelly A · Cantwell, AKN2909QHelman Tom · Evanston, WYN290FCRegistration Pending · Greenwood, MSRegistration pendingN290HADon'T Call Me Shirley LLC · Fort Myers, FLN290MSurging Skyward Inc · Newtown, PAN290MGGeorgia Aviation Authority · Eastman, GAN290NDChristiansen Aviation LLC · Wilmington, DEN290SGinter Aviation LLC · Oakland, MDN290VGAlmy David W · Riverside, CAN29107Wrong Brothers Aviation LLC · Brighton, MIN2910BShively Aurora J · Anchorage, AKN2910DDomke Daniel Carl · Anchorage, AKN2910LBurger Walter F III · Sugar Land, TXN29110Sutton Aircraft Salvage LLC · Palmer, AKN29113Figueroa Angel Lara · Winfield, ALN29114Grey Goose LLC · Wasilla, AKN2911DPagano Ralph V · Cranbury, NJN2911FRegistration Pending · Fayetteville, ARRegistration pendingN2911GOrtega Rolando J · Sanford, FLN2911PHayes Gregory S · Edinboro, PAN2911UNight Sky LLC · Canton, SD
Back to AD 98-21-21 R1