Skip to content

Registered aircraft · 26,231

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.

N2340NFarewell Eric · Lake Wales, FLS/N 12580 N23417Komrowski Ronald H · Jupiter, FLBuilt 1939 · S/N 4-611 N2341DWeniger Gregory M · Burrton, KSBuilt 1952 · S/N 20493 N2341VChilman Nathan · Ellensburg, WABuilt 1948 · S/N 14726 N23421High Exposure Inc · Wilmington, DEBuilt 1968 · S/N 15068938 N23422Air Logistics Group LLC · Winston Salem, NCS/N 15068939 N2342KCole Mark L · Farmington, NMBuilt 1947 · S/N 5069 N2342VDodge Inc · Wilmington, DEBuilt 1948 · S/N 14724 N23435Depinet Thomas E · Mount Gilead, OHS/N 15068944 N23437603 Flight LLC · Nashua, NHBuilt 1968 · S/N 15068945 N2343DShannon Jon M · Conroe, TXBuilt 1952 · S/N 20495 N23440American Sky Aviation LLC · Anna, TXBuilt 1968 · S/N 15068947 N23443Henson Joseph A · Jasper, ALBuilt 1968 · S/N 15068949 N23444Garrett Scott E DBA · Owensville, INBuilt 1968 · S/N 15068950 N23449Mccombs Collin E · Milford, TXBuilt 1939 · S/N 3180 N2344DGough William N · Vancouver, WAS/N 20496 N2344VBoyes Robert L · Benton City, MOBuilt 1948 · S/N 14580 N23453Harrier Aviation LLC · South Saint Paul, MNBuilt 1968 · S/N 15068957 N23458Blue Skies Aircraft LLC · Kalispell, MTBuilt 1968 · S/N 15068961 N2345BBartholomew Don B · Gardnerville, NVBuilt 1948 · S/N 3645 N2345DTravelaire Service Inc · Pueblo, COBuilt 1952 · S/N 20497 N2345NMurphy James L · El Reno, OKBuilt 1946 · S/N 9612 N2345URenkel Albert D · Las Vegas, NVBuilt 1962 · S/N 17249945 N2345VEder Samuel A · Fayetteville, NCS/N 25056 N23460Clark Johnathan W · Coventry, CTBuilt 1968 · S/N 15068963 N23461Egipciaco Jeffrey · Hampstead, NCBuilt 1968 · S/N 15068964 N23463Colmark Bruce A · Sterling, ILBuilt 1939 · S/N 3198 N23469N23469 LLC · Rehoboth Beach, DEBuilt 1968 · S/N 15068970 N2346DSasser Bradley B · Cumming, GABuilt 1952 · S/N 20498 N23473G Force Advantage LLC · Lewes, DEBuilt 1968 · S/N 15068973 N23476Horizon Flight Center LLC · Chesapeake, VABuilt 1968 · S/N 15068976 N2347BPace John W · Bothell, WAS/N 3647 N2347HKerr Phillip D · Beebe, ARS/N 2972 N23486Hite Michael B · Martinsburg, WVBuilt 1968 · S/N 15068983 N23489Knebel Chris DBA · Boston, VABuilt 1968 · S/N 15068985 N2348DNorthern Aviation LLC · Palmer, AKBuilt 1955 · S/N 20500 N2348TWood Thomas D · Irvington, ALBuilt 2019 · S/N 001 N2348UWojnar Ronald T · East Troy, WIBuilt 1962 · S/N 17249948 N23491Mcintosh Dyllon J · Anchorage, AKBuilt 1968 · S/N 15068987 N23492Roller Michael J · Gassville, ARBuilt 1968 · S/N 15068988 N2349BSwift Museum Foundation Inc · Athens, TNBuilt 1948 · S/N 3649 N2349DFedorka Paul R Trustee · Soldotna, AKBuilt 1952 · S/N 20501 N2349EWhitehawk Aviation LLC · Sanford, NCBuilt 1946 · S/N 7AC-5926 N234BBWilson Oscar O Jr · Kountze, TXFirst renewal noticeBuilt 1979 · S/N 001 N234RKShelton Raymond O · Jeanerette, LABuilt 1968 · S/N 15068893 N234RMWilliams Walt A · Mena, ARBuilt 1964 · S/N 17252230 N234TWUplift Aviation LLC · Dover, DEBuilt 1946 · S/N 17812 N23500Windsense LLC · Charleston, SCS/N 15068992 N23502Thompson Timothy L · St Croix Falls, WIBuilt 1968 · S/N 15068994 N23504N23504 LLC · Fort Pierce, FLBuilt 1968 · S/N 15068996

Back to AD 94-05-05 R1