AD 98-21-21 R1
Registered aircraft · 85,620
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.
N169RRGerlach & Associates LLC · Valparaiso, INN169SPVahedi Vafa S · San Diego, CAN169TFStewart Scott A · Anchorage, AKN169TGNordic Sun LLC · Garner, NCN16AHendrix Aviation LLC · Benton, ARN16ABMasselink Ross W · Whitewater, KSN16AKGriffin Steven M · Enterprise, ALN16AMAnimal Health Supply Inc · Vinita, OKN16AWFreas Joseph R · Simi Valley, CAN16AXKing Austin · Abilene, TXN16BBEuroair Consultants LLC · Vero Beach, FLFirst renewal noticeN16BJMarshall John Robert · Missouri City, TXN16CJRoyale Air Service Inc · Fort Myers, FLN16CTOld Boys Aviation LLC · Knoxville, TNN16DADonaire Aviation LLC · Tampa, FLN16DBDivan Richard W · Wautoma, WIN16DPNdmi Inc · Greeneville, TNN16DRHibner Christopher J · Canton, MIN16ECSchnell Michael D · New Bremen, OHN16EJAlphaalpha Aviation LLC · Paragould, ARN16EKCenterline Holdings LLC · Belgrade, MTN16EMB J Air Ltd · Howard, OHN16EZAmerican Aerial Survey Inc · Rancho Murieta, CAN16FSGarrett John J IV · Warner Robins, GAN16GBWester Lawrence Cale · Star, IDN16GMTate Joe D · Eufaula, OKN16GPDeckload Aviation LLC · Kodiak, AKN16HLPlane Fun Inc Tr Trustee · Snellville, GAN16HTAviation Specialties Unlimited Inc · Boise, IDN16JPTrue Grit Wy 2 DBA · Rozet, WYN16JSMace Terry G · Saint James, MNN16KNIgwt Holding LLC · Richardson, TXN16MJHangarfinds LLC · Westminster, CON16MSEnergy Transfer Aviation LLC · Spring, TXN16NHRutgers Nicholas G IV · Camas, WAN16NJBurke Bryan E · Broomfield, CON16PMcmurray Justin John · Durham, NCN16RBHotel Sierra Aviation LLC · Texarkana, TXN16RJParagon Airplane Leasing Co · Fort Myers, FLN16RLKerr John A Jr · Dekalb, ILN16SCWestern Alaska Aircraft Leasing LLC · Pahrump, NVN16SGWard James · Arroyo Grande, CAN16TWBaughman Kevin · Avinger, TXN16VCStallion Leasing LLC · Louisville, KYN16WLLivingston Patricia R · Wasilla, AKN16YBBolea Air Inc · Morgan Hill, CAN16YPSebastian Aero Services Inc · Guaynabo, PRN16ZAVisser Johannes Christoffel · Reno, NVN170Schaffer Grant B · Springfield, ORN1700BJohnson David E · Blair, NE
Back to AD 98-21-21 R1