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.
N2434USkyhawk N2434u LLC · Wilmington, DEN2434XJensen Shaun V · Anchorage, AKN2435ACooper Timothy J · Spearman, TXN2435DThibodeau Dean U · North Pole, AKN2435FBas Part Sales LLC · Greeley, CON2435GVoninski John R · Manlius, NYN2435LAero Science International LLC · Augusta, GAN2435MBrolan Aviation LLC · Kansas City, MON2435QVolare Aviation LLC · Wylie, TXN2435UGalati Stephen E · Florissant, MON2436CHawk Unlimited LLC · Kalispell, MTN2436DSutton Aircraft Salvage LLC · Palmer, AKN2436GDk Futures LLC · Reno, NVN2436MVenture Aviation Inc · Arlington, MAN2436RSilva Gary · Yerington, NVN2436YAlpha Flight Academy · Concord, CANon-citizen corporation, flight hours not reportedN24372Curns James R · New London, WIN2437CFogleman Brian L · Stonewall, LAN2437FKuersten Robert S · Middleton, WIN2437MRock Full Gospel Church · Parkersburg, WVN2437RBlackwelder John W · Columbia, KYN2437UPlanetosea LLC · Doylestown, PAN2437XLudke Arnold · Oakland, NJN2437YRussell John D · Dana Point, CAN2438GWk Aviation LLC · Buffalo, SDN2438RSpeed Hunter Aviation LLC · Franklin, OHN2438UThweatt Greg K · Lodi, CAN2438XRousser Cattle LLC · Amarillo, TXN2438YHoskins Aaron C · Cayuga, NYN2439GJ+J Electric LLC · Seminole, TXN2439LBetts William B · Big Lake, AKN2439USmith Steven T · Charlottesville, VAN2439XAlpha Aero LLC · Biddle, MTN2439YBluegate Engineering LLC · Richburg, SCN243AAFf22 LLC · Scottsdale, AZN243ATAirline Transport Professionals Corp Of USA · Wilmington, DEN243BDBennett Reed J · Reno, NVN243DWSijtsma Wouter · Ladson, SCN243GArcher Aero LLC · Wilmington, DEN243HEason Michael P · Murfreesboro, TNN243JAYale Companies LLC DBA · Indianapolis, INN243MSmall Hills Farms · Durham, CAN243MGGeorgia Aviation Authority · Eastman, GAN243PSN9089 LLC · Lewes, DEN243SDRegistration Pending · Brookings, SDRegistration pendingN243WMoore William · Dalhart, TXN243XJLoiacono Vincent · Sunfield, MIN2440DXing Kong Aviation Service LLC · Atwater, CAN2440LEads Kevin C · Arley, ALN2440UMiller Patrick · Madison, MN
Back to AD 98-21-21 R1