Skip to content

Registered aircraft · 1,889

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:95-19-15-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:95-19-15-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:95-19-15-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:95-19-15-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:95-19-15-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:95-19-15-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.

N3899JEz Bird LLC · Danbury, CTBuilt 1975 · S/N AA5B-0124 N38XLangenfeld Christopher C · Nashua, NHBuilt 1978 · S/N AA5B0899 N399RMEyles Edwin W Jr · Butler, PABuilt 1975 · S/N AA5A-0048 N39GDNovember Sierra Romeo LLC · Byron Center, MIS/N 10250 N3SKMiller Chad L · Shipshewana, INBuilt 1979 · S/N AA5B1219 N400BMDufour William Anthony Jr · Bixby, OKBuilt 1991 · S/N 10038 N400LMGoldberg Gary S · Rockville, MDBuilt 1991 · S/N 10061 N401LDBrady Kevin J Trustee · Afton, OKBuilt 1977 · S/N AA5B0511 N403JREllman Brett M · Cardiff By The Sea, CABuilt 1977 · S/N AA5B0441 N404RBMyrehn Bruce D · Carmel, INBuilt 1972 · S/N AA5-0101 N40FAWright Paul G Trustee · Scotts Valley, CABuilt 1972 · S/N AA5-0114 N414DJSuper Tiger LLC · New York, NYBuilt 1979 · S/N AA5B1298 N414RMMutzman Richard C Trustee · Dublin, OHBuilt 1979 · S/N AA5B1313 N41BJJames Robert D · Anaheim, CABuilt 1991 · S/N 10036 N41DBryson Zachary · Redondo Beach, CAS/N AA5B0993 N41ERDeiulio Michael · Carle Place, NYBuilt 1978 · S/N AA5B0910 N41NCTiger 41nc LLC · Malvern, PABuilt 2004 · S/N 10234 N423Shafer Robert T · Grosse Ile, MIBuilt 1978 · S/N AA5B0986 N42677Swank And Son Inc · Poplar, MTBuilt 1975 · S/N AA5B-0074 N42ARAtlantic Aircraft Holdings LLC · Bohemia, NYBuilt 1979 · S/N AA5B1285 N430BSCoyle Christopher Neal · Portland, ORBuilt 1975 · S/N AA5B-0085 N433Precision Air Inc · Manning, SCBuilt 1979 · S/N AA5B1189 N433AGRinehart Orville J · Forest Lake, MNBuilt 1978 · S/N AA5A0589 N45134Last Chance Lance Auto Sales LLC · Ardmore, OKBuilt 1978 · S/N AA5B0627 N45135Warren Jeremy D · Bloomington, INBuilt 1978 · S/N AA5B0829 N4513NRspp Group LLC · Friendswood, TXBuilt 1978 · S/N AA5B0994 N45141T45141 LLC · Orange, CABuilt 1978 · S/N AA5B1006 N4514AJones N Robert II · Indianapolis, INBuilt 1978 · S/N AA5B0998 N4514BNiemann Professionals P A · Melbourne Beach, FLS/N AA5B0999 N4514FBy The Grace Of God LLC · Miami, FLBuilt 1978 · S/N AA5B1000 N4514NAbc Flying Club Inc · West Mifflin, PABuilt 1978 · S/N AA5B1003 N4514VTorelli Bruce L · Memphis, TNBuilt 1978 · S/N AA5B1005 N4515DTucker Gary · Youngsville, LABuilt 1978 · S/N AA5B1009 N4515LBegich Michael James · Brea, CABuilt 1978 · S/N AA5B1010 N4515NAbsarokee Investment LLC · Billings, MTBuilt 1978 · S/N AA5B1011 N4515UHendrix William A · Flagstaff, AZBuilt 1978 · S/N AA5B1012 N45161Tonry Roger D · Los Angeles, CABuilt 1978 · S/N AA5B1024 N45162Barrell Shelly R · Brownsburg, INBuilt 1978 · S/N AA5B1025 N4516NRegistration Pending · Carlsbad, CARegistration pendingBuilt 1978 · S/N AA5B-1018 N4516TAir Time LLC · Newport, RIBuilt 1978 · S/N AA5B1020 N45175Hale Leland E · Warrington, PABuilt 1978 · S/N AA5B1036 N4517NHosch Stephen R · Louisville, KYBuilt 1978 · S/N AA5B1030 N4517QMarburger James H · Phoenix, AZBuilt 1978 · S/N AA5B1033 N45187Hill Samuel D · Dover, DEBuilt 1978 · S/N AA5B0803 N4518BSmoke Seen LLC · Farmingdale, NYBuilt 1978 · S/N AA5B1038 N4518ERegistered aircraftBuilt 1978 · S/N AA5B1039 N4518KBrush Creek Farmhouse LLC · Valparaiso, INBuilt 1978 · S/N AA5B1040 N4518QLloyd Patrick · Durham, NCBuilt 1978 · S/N AA5B1044 N45191Rinckel Jeannie M · Wilmington, NCBuilt 1979 · S/N AA5B1056 N45199Decou Miller C · Chester Springs, PABuilt 1979 · S/N AA5B1059

Back to AD 95-19-15 R1