Registered aircraft · 40,471

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:80-04-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2') 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:80-04-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
  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:80-04-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
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.

N9301BGimli Son LLC · Fort Lauderdale, FLBuilt 1980 · S/N 172RG0786 N9301DGrammer Brendan L · Canby, ORS/N 22-6312 N9301ERyan Aircraft Holding LLC · Orlando, FLBuilt 1979 · S/N 17272216 N9301JN9301j LLC · Reno, NVBuilt 1966 · S/N 28-3392 N9301VHack Christopher J · Highland Lakes, NJBuilt 1969 · S/N 690086 N9302SLayden John M Jr · Moyock, NCS/N MB-763 N9302YChupito Sabrocito LLC · Paso Robles, CABuilt 1960 · S/N TD-437 N9304DKenneson Robert P DBA · Eureka, KSS/N 22-6315 N9304HWischmeyer Matthew R · Hopewell Junction, NYBuilt 1975 · S/N 17266078 N9304MSweeney William B · Leesville, LABuilt 1966 · S/N 1237 N9305KHitech Aerospace Corp · New York, NYBuilt 1976 · S/N 28-7625175 N9305YN9305y LLC · Wichita, KSBuilt 1960 · S/N TD-438 N9306HAnycomm Corp · Gold River, CABuilt 1975 · S/N 17266079 N9306JHanna Jr Charles W · Kingstree, SCBuilt 1966 · S/N 28-3398 N9306MV1 Consulting Co · Crestwood, KYBuilt 1966 · S/N 1239 N9307DAviatzone LLC · Fort Lauderdale, FLBuilt 1982 · S/N 172RG1114 N9307JWilliams Austen T · Fort Worth, TXBuilt 1966 · S/N 28-3399 N9308JYoung Ashley G · Lexington, NCBuilt 1966 · S/N 28-3400 N9309KVera Rojas Guillermo A · Albuquerque, NMBuilt 1976 · S/N 28-7615194 N930AMDel Mar College · Corpus Christi, TXBuilt 1984 · S/N 0351 N930ERDodson International Parts Inc · Rantoul, KSFirst renewal noticeBuilt 2002 · S/N 4496154 N930GFThierry Robert J · Pottstown, PABuilt 1987 · S/N 930 N930TEPeters James L · Lindon, UTBuilt 2002 · S/N 10209 N9310HLilienthal Donald W · Cyrus, MNBuilt 1975 · S/N 17266080 N9310JBuckwalter Russell · Broadway, VABuilt 1966 · S/N 28-3403 N9311DRegistration Pending · Knoxville, TNRegistration pendingBuilt 1958 · S/N 22-6322 N9311JSentelle Amanda L · Frederick, MDBuilt 1966 · S/N 28-3404 N9311VRegistration Pending · Queen Creek, AZRegistration pendingBuilt 1969 · S/N 690090 N9312DMcdonald Steve W · Lino Lakes, MNBuilt 1958 · S/N 22-6323 N9313CWright Terrence Richard · Tiffin, OHBuilt 1978 · S/N 28-7816459 N9313HFlying Ten Flying Club · Phoenix, AZBuilt 1975 · S/N 17266081 N9313JLockhart Michael B · Redlands, CABuilt 1966 · S/N 28-3406 N9313KStauffer Donald R Jr · Tracy, CABuilt 1976 · S/N 28-7690241 N9314DCallahan Ashton G · Homer, AKBuilt 1958 · S/N 22-6325 N9314EHall Kenneth B · Merritt Island, FLBuilt 1979 · S/N 17272220 N9315DZoviv Michael · Hollywood, FLBuilt 1982 · S/N 172RG1118 N9315ESmith Mark S · Cornville, AZS/N 17272221 N9315JKruthoff Bret · Charles City, IABuilt 1966 · S/N 28-3425 N9315SBradford Alvin L · Northville, MIBuilt 1974 · S/N M-1596 N9315VGroff Joseph J · Colfax, CABuilt 1969 · S/N 690092 N9316JStennis Aviation Group LLC · Mandeville, LABuilt 1966 · S/N 28-3409 N9316MSale Reported · Kalispell, MTSale reportedBuilt 1966 · S/N 670001 N9317VSpaghetti Aviation LLC · Derby, KSBuilt 1969 · S/N 690093 N9318BAnderson Daniel R · Venus, TXS/N 172RG0790 N9318CTarakji Mohamad Hani A · Van Nuys, CABuilt 1978 · S/N 28-7890398 N9318JJohnson Matt · Eugene, ORBuilt 1966 · S/N 28-3411 N9319DCloud Buster LLC · Bloomfield, IABuilt 1958 · S/N 22-6332 N9319HHoffman Stanley L Jr · Bethel, AKBuilt 1975 · S/N 17266084 N9319JAcs Aviation LLC · Wilmington, DEBuilt 1966 · S/N 28-3427 N9319SMeyn Joseph · San Antonio, TXBuilt 1975 · S/N M-1652

Back to AD 80-04-03 R2