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.

N7367THadorn Daniel J · Solon, OHBuilt 1960 · S/N 46967 N7368MHenning Timothy D · Prior Lake, MNBuilt 1958 · S/N 55668 N7369MLacey Joe S · Wilsonville, ALBuilt 1958 · S/N 55669 N736LRegelbrugge Marc · El Dorado, CABuilt 2011 · S/N 1031-2011 N7370ASunrise Aero Inc · Ocala, FLBuilt 1956 · S/N 29470 N7370TVadakin Jeffrey M · Dover, DEBuilt 1959 · S/N 46970 N7370XWilkerson Gale L · Paris, MOBuilt 1962 · S/N 15059470 N7371AArth Richard · Newcomerstown, OHBuilt 1956 · S/N 29471 N7371MNagy Meserole Teresa A · Stevensville, MDBuilt 1958 · S/N 55671 N7372GSky Cops LLC · Midland, TXBuilt 1973 · S/N 15074651 N7372MZavala Marco A · Phoenix, AZBuilt 1958 · S/N 55672 N7373ABaker Thaddeus J · Elk, WAS/N 29473 N7373MFarwell Linda B · Leavenworth, KSBuilt 1959 · S/N 55673 N7374MHofstetter Michael T · Saint James, MOBuilt 1958 · S/N 55674 N7375TMclean Robert M · Baltimore, MDBuilt 1959 · S/N 46975 N7375XBluewater Airmotive Corp · Wilmington, DEBuilt 1961 · S/N 15059475 N7376TClee Jacob M · Chickamauga, GABuilt 1959 · S/N 46976 N7376XGuarino Jack Aubrey · Mobile, ALS/N 15059476 N7377ARfk Aerospace LLC · Clayton, NCS/N 29477 N7377TRock Nh Services LLC · Alpine, TXS/N 46977 N7378MArmstrong Bruce · Port Orchard, WABuilt 1958 · S/N 55678 N7378XHartman Dave L · Barrett, MNBuilt 1961 · S/N 15059478 N7379ANguyen Tuong · Henderson, NVBuilt 1956 · S/N 29479 N7379TPaulino Junior · Poughkeepsie, NYBuilt 1959 · S/N 46979 N737KPPhill-Air Inc · Dover, DEBuilt 1968 · S/N 15067475 N737PACape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1976 · S/N 15078021 N737WFMainero Tanner R · Chehalis, WABuilt 1952 · S/N 25346 N738Massey Air Museum Inc · Massey, MDBuilt 1946 · S/N 1788 N73801Kisela Andrew J · Tecumseh, MIBuilt 1946 · S/N 1861 N73804Cocuzza James V · Hilton, NYBuilt 1946 · S/N 1870 N73806Ledbetter Tim A · Tahlequah, OKS/N 1874 N7380TAndersen William A · Flagstaff, AZBuilt 1959 · S/N 46980 N73811Mertesdorf Daniel R · Aguila, AZS/N 1816 N73820Stuart John R V · Taylorsville, KYBuilt 1946 · S/N 1825 N7382AWretschko Brian W · Phoenix, AZBuilt 1956 · S/N 29482 N7382MPansza Michaelangelo · Poteet, TXBuilt 1958 · S/N 55682 N7383MRegistered aircraftS/N 55683 N7383TLeach Jeff · Terlingua, TXS/N 46983 N7384TMclaughlin James L · Centerburg, OHS/N 46984 N7384XGlenn Larry W · Bunn, NCS/N 15059484 N7385AColli Guido F · Miami, FLBuilt 1957 · S/N 29485 N7385MMorgan Jeffrey E · Peebles, OHS/N 55685 N7385TSeed And Sky Provisions LLC · College Station, TXS/N 46985 N7386ADrum Keith Brian · Clover, SCBuilt 1956 · S/N 29486 N7387AColberg Hans S · Palmer, AKBuilt 1956 · S/N 29487 N7387MHanderson Ronald J · Sitka, AKBuilt 1958 · S/N 55687 N7388TAllen Kenneth C · Spring City, TNBuilt 1959 · S/N 46988 N7389XAa Horizons LLC · League City, TXBuilt 1961 · S/N 15059489 N7390MBechtel Jerold L · Snover, MIBuilt 1958 · S/N 55690 N7390XTruesdell Ronald W · Edgewater, FLBuilt 1961 · S/N 15059490

Back to AD 94-05-05 R1