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.
N2884RSalem Coastal Enterprises LLC · Elizabeth City, NCFirst renewal noticeN2884TBonner John A · Riverside, CAN2884UEast Tenn Pilots Club Inc · Knoxville, TNN2884XAngle Of Attack Flying Company LLC · Springfield, MON2884YTri-Aviation Inc · Amarillo, TXN28852Cae Aviation Academy Phoenix LLC · Mesa, AZN2885BIxi LLC · West Bloomfield, MIN2885CCassee Udo · Anchorage, AKN2885DLehigh Valley Flying Club Inc · Lehigh Valley, PAN2885FDunkly Daniel L · Chico, CAN2885GWisconsin Aviation Inc · Watertown, WIN2885KDierkes Steven P · Henderson, NVN2885LBlevens George A Jr · Franklin, KYN2885MGuilford Lakes Aviation LLC · Greensboro, NCN2885NBrandy Wine Flight School · West Chester, PAN2885QFisher Global LLC · Conway, ARN2885RArrow Flight LLC · Springfield, VAN2885UEda4 LLC · Cresson, TXN2885YMiner Bradford Aviation LLC · Spanish Fork, UTN2886CParks Walter G · Chugiak, AKN2886FWeldon Larry W · Titusville, PAN2886KTallman George L Jr · Ocala, FLN2886QWright Flyers Club Inc · Huber Heights, OHN2886TAtkins Joseph Van · Lenoir, NCN2886UVon Linsowe David J · Vero Beach, FLN2886WBushong Chistopher L · Gulf Shores, ALN2886XMiller Robert Joseph · Fence Lake, NMN2887CKris Noone Air LLC · Wilmington, DEN2887DTwelve Bits LLC · Fort Lauderdale, FLN2887EMeeker Stanton · Squaw Valley, CAN2887LMello Stephen F · Ludlow, MAN2887QAvalon Global Aviation Inc · Lakeland, FLN2887RNaylor Michael Scott · Modesto, CAN2887TSanetra George W · Gary, INN28887Danos Laura S · Hampton Falls, NHN2888CGutwein Harvey R · Francesville, INN2888FLynch Neil E · Ceresco, MIN2888GClark Larry K · Sedalia, CON2888KBooth William R Jr · Sterling, AKN2888QChilds William C · Bridgeport, ALN2888TValenstein Glenn L · Howards Grove, WIN2888UBodo Martin Trustee · Los Altos Hills, CAN28890Slocum Chad W · Pleasant Grove, UTN2889CStowell Ronald A · Westminster, CON2889FLander Kirt E · Kingman, AZN2889GValkyrie Holdings LLC · Lincoln, NEN2889LSouthern Star Aviation LLC · Missoula, MTN2889QAshworth Mark · Stow, OHN2889RAircraft Structural Repair Inc · Hamilton, MTN2889TRegistered aircraft
Back to AD 98-21-21 R1