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.

N766MFPinto Raymond A · Edgewater, FLBuilt 1975 · S/N AA5A-0076 N767FTRenner Brian E · North Port, FLBuilt 1978 · S/N AA5A0646 N76GCEdgerton Richard T · Arlington, WABuilt 1976 · S/N AA5A-0107 N76WPHowes Robert P · Belleview, FLFirst renewal noticeS/N AA5A-0090 N770FTThornton Spencer A · Patchogue, NYBuilt 1978 · S/N AA5A-0772 N772JNBialek Joe · New Smyrna Beach, FLS/N AA5B-0082 N777GC777gc Holdings LLC · Milford, CTBuilt 1975 · S/N AA5B-0167 N777GEAir Float One LLC · Stuart, FLBuilt 1978 · S/N AA5B0741 N777PWAerowest LLC · Independence, ORBuilt 1976 · S/N AA5B-0389 N777YRJrg Enterprises LLC · Gilbert, AZS/N AA5B0669 N778JJGentry Marc E · Pearland, TXBuilt 1979 · S/N AA5B1166 N779WMGoldman Jon L · Smithtown, NYBuilt 1991 · S/N 10044 N783AJApple Ronald L · Fort Myers, FLBuilt 1979 · S/N AA5B1093 N787EBStith Michael P · Boiling Springs, SCS/N AA5-0819 N78GTBennett Wayne M Jr · Puyallup, WABuilt 1978 · S/N AA5B-0853 N78KPYoungblood Dennis L · Crystal River, FLBuilt 1978 · S/N AA5B0758 N78KVShore Dog Aviation LLC · Dover, DEBuilt 1978 · S/N AA5A0632 N78VLAdams Michael · Oxnard, CABuilt 1978 · S/N AA5A-0558 N790ASFly4fun LLC · Buffalo Grove, ILBuilt 1978 · S/N AA5B0918 N7978ACollins Stephen A · Erath, LABuilt 1990 · S/N 99998 N79AQSchmidt Steven Tod · Berthoud, COS/N 10206 N79GGStcyr Marcus · Port Saint Lucie, FLBuilt 1977 · S/N AA5A0371 N79GTSomerville Corby · Sequim, WABuilt 1975 · S/N AA5B1028 N79LNCollins William · Portsmouth, NHS/N AA5B1277 N7LZSpringer Bradley C · Othello, WABuilt 1977 · S/N AA5B0446 N7TYClemens Raymond M · Midlothian, TXBuilt 1974 · S/N AA5-0454 N7YDWatson April L · New Orleans, LABuilt 1978 · S/N AA5B0709 N8005WBartkowiak John D · Moorhead, MNBuilt 1974 · S/N AA5-0562 N800GTBrooks Dallas S · Medina, TNBuilt 1975 · S/N AA5B-0077 N800LMMontague Loyd T · Valdosta, GABuilt 1977 · S/N AA5A0411 N801XMississippi State University · Starkville, MSBuilt 1974 · S/N AA5B-0001 N8034EHill Matthew E · Abingdon, VABuilt 1975 · S/N AA5B0191 N804GASaber Safa · Newburyport, MABuilt 1977 · S/N AA5A-0460 N80CHMoyer Hunter · Rapid City, SDS/N AA5B-0496 N81035Martin William F · San Antonio, TXBuilt 1976 · S/N AA5B0398 N81041Ison Eric L · Irvine, CAS/N AA5B0410 N81043George L Valentine Pc · Marble Falls, TXS/N AA5B0411 N81048Marcy Matthew A · Bluemont, VABuilt 1976 · S/N AA5B0412 N81060Aero Care Inc · Orange, MAS/N AA5B0413 N81068Mclean Sean R · Houston, TXBuilt 1977 · S/N AA5B0415 N81075Vhs Corp · Oxford, CTBuilt 1977 · S/N AA5B0422 N81076Sena Steven G · Palm Coast, FLBuilt 1977 · S/N AA5B0423 N81078Comstock Aviation Group LLC · Reno, NVBuilt 1977 · S/N AA5B0424 N81088Dozenko William P · Milltown, NJBuilt 1977 · S/N AA5B0425 N81089Ffs Air LLC · Indianapolis, INBuilt 1977 · S/N AA5B0426 N81094Williamson Peter R · Bethesda, MDBuilt 1977 · S/N AA5B0427 N81095Bartley Stefanie E · Lexington Park, MDBuilt 1977 · S/N AA5B0428 N81103Reding Thomas M Jr · Taft, TXBuilt 1977 · S/N AA5B0430 N81104Barber Bradly · Metamora, MIS/N AA5B0431 N81112Odyssey Flyers LLC · Kalispell, MTBuilt 1977 · S/N AA5B0433

Back to AD 95-19-15 R1