Skip to content

Registered aircraft · 26,230

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.

N1133YGreen Mountain Semiconductor Inc · Burlington, VTS/N 15059533 N1134FScialabba John E · Columbus, OHBuilt 1966 · S/N 17254729 N1134HFeldhusen Lawrence E · Yankeetown, FLBuilt 1948 · S/N 15AC-148 N11351Lanier Equipment Leasing LLC · Gainsville, GABuilt 1973 · S/N 15075343 N11352Kimmel Nathan · Lancaster, PABuilt 1973 · S/N 15075344 N11353Denmark Brooks Mclaughlin · Clayton, NCS/N 15075345 N11356Melton Joseph W · Conway, ARS/N 15075348 N11358Lavalle David · Centerburg, OHBuilt 1973 · S/N 15075350 N1135BGardner Gary A · Estherville, IABuilt 1947 · S/N 5762 N1135DRodriguez Daniel Royo · Hagerstown, MDBuilt 1951 · S/N 15698 N1135HSale Reported · Fort Smith, ARSale reportedBuilt 1948 · S/N 15AC-151 N1135MLopez Ferco Capdevila · Port Saint Lucie, FLS/N 15071735 N1135YSwanson Isaac · Wasilla, AKS/N 15059535 N11363Fireland Christopher G · Brownwood, TXS/N 15075354 N11365Kimberk Frederick S · Cambridge, MABuilt 1973 · S/N 15075355 N11366Registration Pending · Jacksonville, FLRegistration pendingBuilt 1973 · S/N 15075356 N11367Canniff Dustin P · Sutton, AKBuilt 1973 · S/N 15075357 N11369Abrams Adrian L · Palmer, AKS/N 15075359 N1136DWatson Frank H · Central Point, ORBuilt 1951 · S/N 15699 N1136HMusgrove Louis A Jr · Cumming, GABuilt 1948 · S/N 15AC-144 N1136MHiggins Derrick · Arbyrd, MOBuilt 1970 · S/N 15071736 N11371Sale Reported · Thomaston, GASale reportedBuilt 1973 · S/N 15075361 N11373Huffman Aviation LLC · Burleson, TXBuilt 1973 · S/N 15075363 N1137FWisti James G · New Hudson, MIBuilt 1966 · S/N 17254732 N11380Roush Daniel E · Shoals, INBuilt 1973 · S/N 15075369 N11387Cloud Nine Aviation Inc · Picayune, MSBuilt 1973 · S/N 15075376 N11389Swinnich Kenneth · Wellsboro, PABuilt 1973 · S/N 15075378 N1138HAgaliotis Paul E · San Martin, CABuilt 1948 · S/N 15AC-149 N1138ZMuffoletto Matthew · Anchorage, AKBuilt 1969 · S/N 15069760 N11392Verrill John B · Shelburne, NHBuilt 1974 · S/N 15075381 N11393Brough James P II · Nashua, NHBuilt 1973 · S/N 15075382 N11395Coleman Darryl W · Fayetteville, GABuilt 1973 · S/N 15075384 N11396Jeffries Holdings LLC · Bargersville, INBuilt 1973 · S/N 15075385 N11397Nydam Adam Adrian · Lawrenceburg, KYS/N 15075386 N11399Registered aircraftN-number assigned, not yet registeredS/N 15075388 N1139DOborny Alan R · Choteau, MTBuilt 1951 · S/N 15702 N1139FGifford Kenneth A · Appleton, WIBuilt 1966 · S/N 17254734 N113BEEbbinga William R · Griswold, IAS/N 56431 N113CWDawson John W · Milton Freewater, ORBuilt 1946 · S/N 11-3 N113MKoenigsberg Douglas D · Baltimore, MDBuilt 1954 · S/N A-1 N113NDFox Flight Instruction LLC · Jacksonville, FLBuilt 1967 · S/N 15067823 N113PBRegistration Pending · North Little Rock, ARRegistration pendingBuilt 1976 · S/N 15078263 N113SCChief Aviation LLC · Azle, TXBuilt 1952 · S/N 18-2003 N113SSSoutheastern Oklahoma State University · Durant, OKBuilt 1975 · S/N 15076645 N113WMStarke Charles H III · Weirsdale, FLBuilt 1966 · S/N A-114 N113WWSpitfire Aviation Inc · Wilmington, DEBuilt 1946 · S/N 14681 N11405Cornelius Steven E · Wasilla, AKBuilt 1973 · S/N 15075394 N11407Harrop Brian · Mesa, AZBuilt 1973 · S/N 15075396 N11409Cambium International Inc · Cary, NCBuilt 1973 · S/N 15075398 N1140EErickson Keith E · Anchorage, AKS/N 7AC-4696

Back to AD 94-05-05 R1