AD 98-21-21 R1
Registered aircraft · 85,616
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.
N11421Beach Prairie LLC · Cedar Rapids, IAN11423Boland Aviation LLC · Newton, NJN1142FHart James A · Arlington, VAFirst renewal noticeN1142GMorgan Robert Brian · Ozark, MON1142LMcdonald Brennan P · Orlando, FLN1142MStewart Eric · Lott, TXN1142QSteely Paul · Williamsburg, KYN1142THaskell Bryan William · Belmont, NCN1142XAerofeather Aviation Inc · Suffolk, VAN1143AStraeter Eckhard · Lempster, NHN1143FWilson Dan · Saginaw, TXN1143KBishop Nathan Wesley · League City, TXN1143MCastelletti Mark Anthony Trustee · Casa Grande, AZN1143NMichael K Bristow · Smyrna, GAN1143WRiner Mark G · Bartlesville, OKN1144FBandit Air LLC · Stowe, PAN1144KYoung Bradley M · Vancouver, WAN1144MCcr Aviation LLC · Kalispell, MTN1144NHanovich Robert L Jr · Flagstaff, AZN1144WNimmo Lawrence · Cordova, MDN1144XFly Texas Sky LLC · Arlington, TXFirst renewal noticeN1144ZBay Lux Ventures LLC · Tampa, FLN1145FGurke George J · Anchorage, AKN1145TWilliams Thomas J · Burr Ridge, ILN1145UWws Air LLC · Savannah, GAN1146FLarson Larry D · Sargeant, MNN1146HLtk Air Inc · North Wilkesboro, NCN1146JAdam Spencer · New York, NYN1146LSak Aviation LLC · Cheney, KSN1146PElkin Christopher E · Talpa, TXN1146TGandhi Mehul · Hayward, CAN1147N7371y LLC · Waterford, MIN1147AShipley & Son Ltd · Capitan, NMN1147DWesterhold Wayne E · Cary, NCN1147FParker Robert M · Hurst, TXN1147GIcarus Transport LLC · Charlotte, NCN1147HSpacious Skies LLC · Overland Park, KSN1147XPax Flyers LLC · Hollywood, MDN1148BBallard Neil B · Mankato, MNN1148FReed Roger · Lebanon, KYN1148GJackson Brian · Oklahoma City, OKN1148NForbes Ryan C · Newnan, GAN1148TCorlett Samuel E · Fort Worth, TXN1148UCaromac LLC · Florence, SCN11495Risoldi John L Sr · Kitty Hawk, NCN1149BStefenelli Aviation N Tr Inc Trustee · AtterseeN1149FLemery Aaron D · Chattaroy, WAN1149GShine Flyer LLC · Kalispell, MTN1149HN1149h Inc · Pembroke Pines, FLN1149LAviation Trust Company LLC Trustee · Oklahoma City, OK
Back to AD 98-21-21 R1