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.

N300RGRein Richard C · St George, UTS/N AA5A-0159 N3050JRegistration Pending · Lake Frederick, VARegistration pendingBuilt 1976 · S/N AA5A0082 N311CKLima Tango Aviation LLC · Mount Dora, FLBuilt 1977 · S/N AA5B0591 N311LTSampson Terry W · Kimberly, ALBuilt 1975 · S/N AA5A-0035 N311TAWalgren John A · Tolono, ILS/N AA5B0488 N313TAD A Consulting Inc · Orlando, FLBuilt 1977 · S/N AA5A0312 N315Luhrs Inc · Wilmington, DES/N AA5B-0242 N315YHancock Phil R · Live Oak, FLBuilt 1977 · S/N AA5B-0532 N31RBTigre Ecossais Aviation Inc Trustee · Wilmington, DEBuilt 1975 · S/N AA5B-0156 N31THNet Air Co · Monroe, MIBuilt 1979 · S/N AA5B1142 N321ESQualitair LLC Trustee · MichelstadtBuilt 1979 · S/N AA5A-0729 N321GDFirst Light Inc · Lafayette, LABuilt 1977 · S/N AA5B0461 N321JBCox Kevin · Lexington, KYBuilt 1978 · S/N AA5A0560 N321MPAker Carroll Gregory · Titusville, FLBuilt 1991 · S/N 10084 N321WSWrong Brothers Aviation LLC · Wilmington, DEBuilt 1973 · S/N AA5-0327 N322KLBuyair LLC · Valdosta, GAS/N 10220 N324DHWood Thomas E · Sherrills Ford, NCBuilt 1979 · S/N AA5B1259 N325WVEphofen Jack O · Allegan, MIBuilt 1973 · S/N AA5-0393 N329PWalther Cameron R · Hallam, NEBuilt 1977 · S/N AA5A0329 N32ERWolfe Bruce · Fredericksburg, TXBuilt 1978 · S/N AA5B0905 N32NNTiger 32nn LLC · Manchester, NHS/N AA5B-0602 N32SKKukolich Stephen G · Tuscon, AZBuilt 1977 · S/N AA5A0492 N3322KHamilton Roger A Trustee · Pisgah Forest, NCBuilt 1975 · S/N AA5B-0046 N332JBMcalee Jeremy D · St Johns, FLBuilt 1976 · S/N AA5B0359 N333FKPonnada Jayaram · Milton, GABuilt 1979 · S/N AA5A0853 N333FVGreco James L · Mount Pleasant, SCBuilt 1976 · S/N AA5A0276 N33ERCrump Edward J · Boonton, NJBuilt 1978 · S/N AA5B0884 N33JJFincor Inc · Miami Beach, FLBuilt 1972 · S/N AA5-0061 N33JXProuty Timothy V Trustee · North Providence, RIBuilt 1977 · S/N AA5B0585 N345AEChannel City Flyers Inc · Santa Barbara, CAFirst renewal noticeBuilt 1975 · S/N AA5A-0063 N356PVDalton Steven J · Plano, TXBuilt 1973 · S/N AA5-0303 N358RWHawley Elizabeth B · Wichita Falls, TXBuilt 1979 · S/N AA5B1066 N365PSFainer Jeffrey M · San Diego, CABuilt 1978 · S/N AA5A0552 N36ERSkytypers Inc DBA · Las Vegas, NVBuilt 1978 · S/N AA5B0897 N3749Neuville Gregory L · Fort Myers, FLFirst renewal noticeBuilt 1979 · S/N AA5B1097 N37500Clark Jeremy · Auburn, ALBuilt 1977 · S/N AA5A-0353 N37501Hancock Stephen D · Alexandria, VABuilt 1977 · S/N AA5B-0408 N3750ZJones Ray E · Brazil, INBuilt 1976 · S/N AA5B-0114 N3752WCheever Dennis E · Bakersfield, CABuilt 1979 · S/N AA5B-1188 N37644Hoyt Patrick W · Cresson, TXS/N AA5B-1294 N376DMTichy Cotton V · Atascadero, CABuilt 1977 · S/N AA5A-0376 N376VGoodpasture Tim W · Mannford, OKS/N AA5A0546 N3772CBowman Michael S · Tucker, GAFirst renewal noticeBuilt 1979 · S/N AA5A-0884 N3773NSkytypers Inc DBA · Las Vegas, NVBuilt 1979 · S/N AA5B-1229 N3773YSirius Aeronautics LLC · Buda, TXS/N AA5B-1273 N3791ZR B E Holding LLC · Wilmington, DES/N AA5B-1254 N379NLDe Av8r LLC · Lewes, DEBuilt 1978 · S/N AA5B0822 N382NHendren Ronald P · Clarkston, MIBuilt 1977 · S/N AA5A0519 N384LVFox Pat T · Muscatine, IABuilt 1977 · S/N AA5B0583 N388CKayo Properties LLC · Belmont, MSBuilt 1977 · S/N AA5A0388

Back to AD 95-19-15 R1