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

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.

N123GLAir Care Leasing LLC · Lamar, COBuilt 1973 · S/N 18261902 N123GSLou Ann Inc · Los Altos, CABuilt 1979 · S/N E-1464 N123HAR & R Aviation Services LLC · Festus, MOBuilt 1972 · S/N 17261048 N123HMComanche Air LLC · Mokena, ILBuilt 1961 · S/N 24-2912 N123JCDippolito Mario M · Sherwood, ARS/N 28-22500 N123JJRotorwings Aviation LLC · Hebron, NEBuilt 1972 · S/N TC-1421 N123JTGraham Richard A · Wichita Falls, TXBuilt 1965 · S/N T210-0019 N123JVDowning Danny L · Kilgore, TXBuilt 1955 · S/N D-4024 N123KCHelms Brandon M · Indian Trail, NCBuilt 1976 · S/N 32R-7680431 N123KLWings Over The Rockies LLC · Wittmann, AZBuilt 1977 · S/N 18265746 N123KRRuhlin Thomas J · Lakewood Ranch, FLBuilt 1977 · S/N 28-7716242 N123KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1977 · S/N 17268627 N123KTHolliday Paul B · Kiln, MSBuilt 1963 · S/N 21058218 N123LGDaniels Garry E · Humboldt, KSBuilt 1974 · S/N 17263957 N123LJRegistered aircraftBuilt 1965 · S/N 18051526 N123LMMccleary Bryan W · Marion, OHBuilt 1967 · S/N 24-4669 N123LUSutton Aircraft Salvage LLC · Palmer, AKS/N 32394 N123MCNelson Isaac · Saint Croix Falls, WIS/N 21063578 N123MFAronhalt Daniel E · Columbus, INBuilt 1968 · S/N 32-1069 N123MKSolomon Steven · Cherry Hill, NJBuilt 1965 · S/N 26-141 N123MMMuller Miles O · Staples, TXBuilt 1986 · S/N E-2332 N123MNFoster Aviation And Mobile Maintenance LLC · Dublin, VABuilt 1972 · S/N 310Q0602 N123PJacobs Michael · Jay, OKBuilt 1955 · S/N 23-397 N123PAFly For Fun Inc · Niceville, FLBuilt 1978 · S/N 24-0648 N123PGFinlayson William S · Annapolis, MDBuilt 1965 · S/N 3154 N123PTScheller Erik G Trustee · Gig Harbor, WAS/N 31-8112020 N123PVSandlapper Aviation Of De Inc · Bennington, VTBuilt 1973 · S/N 27-7305039 N123PYDotson Daniel · Holly Springs, MSBuilt 1966 · S/N 17254641 N123RGChurch Brett L · Whitefish, MTBuilt 1968 · S/N D-8816 N123RKPlane Fun Inc Tr Trustee · Snellville, GABuilt 1980 · S/N CE909 N123SWBelschner Custom Meats · Amherst, NEBuilt 1972 · S/N 28-7305105 N123TCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1962 · S/N DH-339 N123TJClover Management Systems Inc · Sanford, FLBuilt 1978 · S/N 44-7995045 N123TMJaars Inc · Waxhaw, NCS/N U20601768 N123TTMidwest Athletic Supply LLC · San Marcos, CABuilt 1979 · S/N 17272784 N123TWGrandy Boyd · Smoot, WYBuilt 1974 · S/N E-518 N123TXGofly Corporation · Port Ewen, NYBuilt 1968 · S/N 28-11108 N123UAwg Aviation LLC · Ainsworth, IABuilt 1968 · S/N 21059004 N123UASchlabach Sharon · Lakewood Rch, FLBuilt 1990 · S/N 28-90137 N123UKSch Aviation Inc Trustee · NorfolkBuilt 1990 · S/N 24-3167 N123UPApache Underground And Excavating LLC · Lakeside, AZBuilt 1969 · S/N 18259985 N123USLow Gary Mike · Southside, ARBuilt 1982 · S/N TH-1335 N123VCSan Bernardino Community College District · San Bernardino, CABuilt 1973 · S/N 17261890 N123VJKopp Daniel D · Buckeye, AZBuilt 1965 · S/N 18256102 N123VRLewis Edward M · Mesquite, NVS/N 210-59891 N123WBHighview LLC · Brentwood, TNBuilt 1978 · S/N TH-937 N123WGThornhill Shaun · Greenville, OHBuilt 1963 · S/N 18254997 N123WJBas Part Sales LLC · Greeley, COS/N 24-1620 N123YAAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1979 · S/N 32-7940258 N123ZAFlying Colors Airparts Inc · Leesburg, FLBuilt 1970 · S/N 17259361

Back to AD 98-21-21 R1