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

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

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.

N172CGWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17264991 N172CHCrosby Flying Services LLC · Fort Worth, TXBuilt 1971 · S/N 17260288 N172CJAlsworth Caleb J · Port Alsworth, AKBuilt 1968 · S/N 17257173 N172CLByrne Matthew A · West Allis, WIS/N 17267882 N172CPShevchenko Antonina · Henderson, NVFirst renewal noticeBuilt 1979 · S/N 17273471 N172CWGoddard William W · Apple Valley, CABuilt 1974 · S/N 17263325 N172DBK&T Aviation LLC · Milton, PABuilt 1976 · S/N 17268440 N172DFMajercik Donald A · Jericho, VTBuilt 1963 · S/N 17250946 N172DGGrass Daniel L Trustee · Penn Valley, CABuilt 1972 · S/N 17260743 N172DKVertikle Enterprises LLC · Cheyenne, WYS/N 17250974 N172DLKling Aviation Inc · Friendswood, TXBuilt 1975 · S/N 17266166 N172DMErquiaga Jeff H · Rushville, NEBuilt 1978 · S/N 17270835 N172DSJb Air Services LLC · Framingham, MABuilt 1975 · S/N 17265198 N172DTMilam Six LLC · Milam, TXBuilt 1965 · S/N 17253770 N172DVLima Tango Aviation LLC · Mount Dora, FLBuilt 1968 · S/N 17256625 N172EPlymouth Flying Club Inc · Plymouth, NHBuilt 1974 · S/N 17263335 N172EBMiller David A · Kodiak, AKBuilt 1973 · S/N 17261560 N172ECNilo Aviation LLC · Arley, ALBuilt 1976 · S/N 17266723 N172EGMondloch Jesse R · Freedom, WIBuilt 1964 · S/N 17252003 N172EMUnited States Aviation Consultants LLC · Davie, FLS/N 17267336 N172EPCp Aviation Inc · Santa Paula, CABuilt 1976 · S/N 17267932 N172EQSpeck Richard G · Wilmington, DEBuilt 1973 · S/N 17262251 N172ESAero Quest LLC · Olive Branch, MSBuilt 1969 · S/N 17258019 N172EWWoodrum Stephen D · Mesa, AZBuilt 1975 · S/N 17265167 N172EZCastille Leonard E · Breaux Bridge, LABuilt 1964 · S/N 17250712 N172FCWmrc Properties LLC · Fort Pierce, FLBuilt 1978 · S/N 17270224 N172FGFly 172n LLC · Peoria, AZBuilt 1976 · S/N 17267586 N172FMStern Jason C · Roscoe, ILBuilt 1969 · S/N 17258008 N172FPOceanic Air LLC · Key West, FLBuilt 1971 · S/N 172-59815 N172FTAirlink California LLC · Diamond Bar, CAS/N 17270486 N172FXFlexjet LLC · Cleveland, OHBuilt 1978 · S/N 17271381 N172GSuperhawk Inc · Casselton, NDBuilt 1979 · S/N 17271959 N172GBAig Aeronautics LLC · Guaynabo, PRS/N 17260336 N172GCDairy Air Inc · Wyoming, PABuilt 1968 · S/N 17257234 N172GFDel Martin Lp · Spring, TXFirst renewal noticeBuilt 1965 · S/N 17252903 N172GLGlover Anthony R · Louisville, KYBuilt 1960 · S/N 17247944 N172GMWings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267127 N172GRN172gr LLC · Tamarac, FLBuilt 1973 · S/N 17261991 N172GSEisler Jacob · Wellington, FLS/N 17271917 N172GTAileron Buzz LLC · Daytona Beach, FLBuilt 1971 · S/N 17259831 N172GVJackson Gordon W · Fort Worth, TXBuilt 1961 · S/N 17248487 N172GXSingleton Randy V · Shippensburg, PABuilt 1965 · S/N 17252756 N172HMatusky Gregory S · Cal Nev Ari, NVBuilt 1967 · S/N 17256262 N172HDSchadt Andrew M · Edwardsville, ILBuilt 1976 · S/N 17267191 N172HFBuiqui Aerospace Corp · Kissimmee, FLS/N 17264634 N172HLStankiewicz Adam · Merrimack, NHBuilt 1970 · S/N 17259079 N172HRArlington Flyers Club · Mill Creek, WABuilt 1977 · S/N 17269272 N172HTAuto Outlet Of Irvington LLC · Irvington, NJS/N 17257091 N172JAPalmenteri Louis J · Rhome, TXBuilt 1966 · S/N 17254401 N172JBWood Jonathan R · Sedgwick, MEBuilt 1973 · S/N 17262206

Back to AD 98-21-21 R1