Skip to content

Registered aircraft · 26,232

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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.

N6142KCreamer Ryan Patrick · Tower Hill, ILBuilt 1975 · S/N 15077550 N6142TMiller Timothy A · Opheim, MTBuilt 1964 · S/N 15060842 N6143GSale Reported · Brodhead, WISale reportedBuilt 1969 · S/N 15071643 N6144EBlack Kenneth Cory · Chillicothe, OHBuilt 1958 · S/N 46244 N6144GHoke Christopher R · Kernersville, NCS/N 15071644 N6145ESaylor Willa G · Newburg, PAS/N 46245 N6145FAlpha Bravo Aviation LLC · Trophy Club, TXBuilt 1973 · S/N A1500426 N6145TJones Blake · Selma, ALBuilt 1964 · S/N 15060845 N6146EDahlberg James C · Ogilvie, MNBuilt 1958 · S/N 46246 N6146FHeppner Sebastian · Fishers, INS/N A1500427 N6146TDanyal David · Lake Stevens, WABuilt 1964 · S/N 15060846 N6147TBooks Clifton B · Harrah, OKBuilt 1964 · S/N 15060847 N6148EPlant Robert L · Churubusco, INBuilt 1958 · S/N 46248 N614DCRegistered aircraftBuilt 2004 · S/N 011 N614KAPittman David S · Simpsonville, SCBuilt 1946 · S/N 16978 N615Elliott Ronald H · Alexandria, LAS/N 2867 N6150ENeedham George T · Seattle, WABuilt 1958 · S/N 46250 N6150GStockton Raymond L · Pearl City, HIBuilt 1969 · S/N 15071650 N6150THaug Michael A · Spring Lake, MIBuilt 1964 · S/N 15060850 N6151KRomano Aviation LLC · Barrington, RIBuilt 1975 · S/N 15077555 N6152ESkyranch Knoxville Youth Inc · Knoxville, TNS/N 46252 N6154GGrinnell Matthew J · Auburndale, FLBuilt 1969 · S/N 15071654 N6155FHalladay Roy · Erie, COBuilt 1973 · S/N A1500432 N6155GChin Benny C · Chandler, AZS/N 15071655 N6155WKroger William A Jr · Newberg, ORBuilt 2007 · S/N WAK2001HH N61561Tangent Aviation LLC · Oro Valley, AZS/N 15060976 N6156EPaynter John W · West Bath, MEBuilt 1958 · S/N 46256 N6156TGalster Gabriel M · Royal, ARS/N 15060856 N6157ERegistered aircraftBuilt 1958 · S/N 46257 N6157TVlk Mark J · Moses Lake, WABuilt 1964 · S/N 15060857 N6158EHepler Paul C · Harrisburg, PABuilt 1958 · S/N 46258 N6158TWilliams James D · Lyons, COBuilt 1964 · S/N 15060858 N615AHRusty Crate LLC · Wynne, ARS/N 17252337 N615CBBrown William C · Bedias, TXBuilt 2007 · S/N 601-048S N6160EBurnette Richard A · Hampton, GABuilt 1958 · S/N 46260 N6160UHattensty Robert Wade · Burleson, TXS/N 1937 N6161GGough James L · Hesston, KSBuilt 1969 · S/N 15071661 N6161KSmith William F · Hindsville, ARBuilt 1975 · S/N 15077562 N6162HD & D Air Inc · Valentine, NEBuilt 1946 · S/N 19330 N6163KJennings Steven W · Austin, TXS/N 15077563 N6163MN6163m LLC · Eugene, ORBuilt 1962 · S/N 17249550 N6164TRubin Andrew C · Rochester, NHBuilt 1964 · S/N 15060864 N6165EBailey Frank W · White City, ORBuilt 1958 · S/N 46265 N6165GPartida Carlos · Delray Beach, FLBuilt 1969 · S/N 15071665 N6166EAshabranner Kevin T · Port Saint Joe, FLBuilt 1958 · S/N 46266 N6167FJohnson Susan J · Chelan, WABuilt 1973 · S/N A1500437 N6167TBurton William F · Shiloh, NJBuilt 1964 · S/N 15060867 N6168EFoster Marcus R · Mesa, AZBuilt 1958 · S/N 46268 N6169EVick Troy · Normangee, TXS/N 46269 N6169GKingdom Air Corps · Sutton, AKBuilt 1969 · S/N 15071669

Back to AD 94-05-05 R1