Skip to content

Registered aircraft · 40,473

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.

N555JBPerkins Robert Tahte · Anchorage, AKBuilt 1959 · S/N 18-7102 N555JKTenhoopen Thomas W · Livonia, MIBuilt 1973 · S/N 282-74 N555JMFingerlakes Area Pilots Inc · Seneca Falls, NYBuilt 1979 · S/N 28-7916412 N555LASouth Latitude Aviation Service LLC · Humble, TXBuilt 1976 · S/N 17268207 N555NAWe Warrior Three LLC · Paragould, ARBuilt 1974 · S/N 28-7415500 N555PAPyle Dana C · Naples, FLBuilt 1972 · S/N 28-7225476 N555PBM5 LLC · Kit Carson, COBuilt 1973 · S/N 287305016 N555PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842092 N555RSR&M Aviation LLC · Austell, GABuilt 1963 · S/N M-412 N555SLHuffman Jacob M III · Burleson, TXBuilt 1973 · S/N 17262755 N555SMWalla Walla University · College Place, WABuilt 1973 · S/N 17261805 N555TWMccabe Robert J Trustee · Cherry Hill, NJBuilt 1973 · S/N 28-7305578 N555UHAlba Aviation Services Inc · Scottsdale, AZBuilt 2004 · S/N 3550 N555UMBoretide Aviation LLC · Anchorage, AKBuilt 1971 · S/N 28-7105078 N555VCBassetti Cody J · Paso Robles, CABuilt 1969 · S/N 28-26049 N555WRCentral Ridge Consulting Inc · Beverly Hills, FLBuilt 1994 · S/N 20187 N555WUChapman Leland R · Carencro, LABuilt 2000 · S/N 23897 N555XCTriple Five Air LLC · Redwood City, CABuilt 2004 · S/N S 52 N555YFRathje Norm · Wills Point, TXBuilt 2004 · S/N 70049 N555ZFuller Michael B · Winter Garden, FLBuilt 1952 · S/N 18-913 N555ZHWurth Gary P · Rochester, NYS/N 17268439 N555ZWGrenda Adam J · King Salmon, AKBuilt 2010 · S/N HSC-2010-01 N55605Parrish Don A · Plains, TXBuilt 1973 · S/N 28-7325440 N55606Falcon Aviation Academy Corp · Chino, CANon-citizen corporation, flight hours not reportedBuilt 1973 · S/N 28-7325441 N55608Thunderbird Aviation LLC · Shawnee, OKS/N 28-7305423 N5560FVandyke Jason M · Gettysburg, PABuilt 1968 · S/N 28-24900 N5560MA-1 Auto Reyclers · Columbia, MOBuilt 1967 · S/N 097 N55617Critchett Reggie D · Sterling Heights, MIBuilt 1973 · S/N 28-7325431 N55618Keller Paul D · Burlington, CTBuilt 1973 · S/N 28-7325443 N5561QRoberson Richard J Jr · Panama City, FLBuilt 1965 · S/N 2969 N55621Wood Steve · Fresno, CABuilt 1973 · S/N 28-7325446 N55622Detor Properties Inc · Rochester, NYBuilt 1973 · S/N 28-7305426 N55623Vector Aviation Services LLC · Groesbeck, TXBuilt 1973 · S/N 28-7305427 N5562FTom Brian A · Santa Clarita, CABuilt 1968 · S/N 28-24902 N5562UWilkosz Robert · Tampa, FLBuilt 1969 · S/N 28-26288 N5563QFishero John D · Spring, TXBuilt 1965 · S/N 2970 N5563UBlair James S · Beltsville, MDBuilt 1970 · S/N 28-26882 N55640Adams Charles G III · Tawas City, MIBuilt 1973 · S/N 28-7305430 N55646Bluto Paul · Branson, MOBuilt 1973 · S/N 28-7325450 N55648Pic Aviation Inc · Bloomsburg, PABuilt 1973 · S/N 28-7305434 N5564FVazquez Oscar C · Moreno Valley, CABuilt 1968 · S/N 28-24904 N5564UGoldinger Matthew L · Ligonier, PABuilt 1969 · S/N 28-26291 N55656Denovellis Dennis T · Sidney, NEBuilt 1973 · S/N 28-7325453 N55659Beiderman Allan R · Melbourne, FLBuilt 1973 · S/N 28-7305439 N5565FHenley Brett · Manchester, TNFirst renewal noticeBuilt 1968 · S/N 28-24905 N5565PGrant Zachary J · Indianapolis, INBuilt 1958 · S/N 24-629 N5565UFiebich Stephan C · Kearney, MOBuilt 1969 · S/N 28-26292 N55667Stanick Paul J · Whitinsville, MABuilt 1973 · S/N 287305438 N5566UKingsbury Janet L · Miramar, FLBuilt 1969 · S/N 28-26293 N5566WRegistered aircraftBuilt 1962 · S/N 28-660

Back to AD 80-04-03 R2