Skip to content

Registered aircraft · 56,578

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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.

N1132UMjolhus Knut G · Amarillo, TXBuilt 1982 · S/N 21064669 N1132WC Flying K Aviation LLC · Savery, WYFirst renewal noticeBuilt 2006 · S/N 172S10125 N1132XWest Coast Equipment Leasing LLC · Englewood, COBuilt 2006 · S/N 172S10316 N11330Leikala Douglas A · Fairport Harbor, OHBuilt 1975 · S/N 17702332 N11331Gervais Andre B · Griffin, GABuilt 1973 · S/N 15075334 N11332Byrd Craig Stephen · Laurel, MSS/N 15075335 N1133DBohl Howard M · Temecula, CABuilt 1951 · S/N 15696 N1133FFinnelly Barry J · Snohomish, WABuilt 1966 · S/N 17254728 N1133MRobinson Lanis A · Clanton, ALBuilt 1970 · S/N 15071733 N1133UMustachio Donald · East Stroudsburg, PABuilt 1976 · S/N 17266862 N1133YGreen Mountain Semiconductor Inc · Burlington, VTS/N 15059533 N1134DFma Auto Sales LLC · Greensboro, NCBuilt 2005 · S/N 18281605 N1134FScialabba John E · Columbus, OHBuilt 1966 · S/N 17254729 N1134UWells William L · Santa Cruz, CABuilt 1976 · S/N 17266863 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 N1135DRodriguez Daniel Royo · Hagerstown, MDBuilt 1951 · S/N 15698 N1135FLong Duane C · Baskin, LAS/N 17272961 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 N11368Adkins Ian B · Dahlonega, GABuilt 1975 · S/N 17702333 N11369Abrams Adrian L · Palmer, AKS/N 15075359 N1136DWatson Frank H · Central Point, ORBuilt 1951 · S/N 15699 N1136GBurnside Thomas L · Kansas, ILBuilt 1978 · S/N 18266300 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 N11378Registered aircraftBuilt 1975 · S/N 17702335 N11379Bas Part Sales LLC · Greeley, COBuilt 1999 · S/N 20608077 N1137FWisti James G · New Hudson, MIBuilt 1966 · S/N 17254732 N1137MN1137m LLC · Bentonville, ARBuilt 1977 · S/N 21061921 N1137UFoscap Air LLC · Las Vegas, NVBuilt 1976 · S/N 17266866 N1137Y412 Jackson Site Development LLC · Oxford, MSBuilt 2005 · S/N 18281602 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 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

Back to AD 79-10-14 R1