Skip to content

Registered aircraft · 8,138

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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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.

N2111ZNunn Henry · Noble, OKBuilt 1973 · S/N 28-7305515 N2122RAdventure North Flying Service LLC · Aitkin, MNS/N 28-5464 N2127RCohen Blanche F · Aurora, COBuilt 1969 · S/N 28-5465 N212FMooney Daniel V · Malvern, PABuilt 1971 · S/N 28-7205015 N2130RAscend Aviation LLC · Ira, MIBuilt 1969 · S/N 28-5466 N2132TMatejcek Lina M · Owatonna, MNBuilt 1971 · S/N 28-7125448 N2134RVanek Peter · Sedona, AZBuilt 1969 · S/N 28-5467 N2137TWatson Jay C · Midland, TXBuilt 1971 · S/N 28-7105160 N2140TCupples Thomas Joseph · San Marcos, CABuilt 1971 · S/N 287105162 N2142RFieldhouse Warren W · Ocala, FLBuilt 1969 · S/N 28-5469 N2143TRahim Shamim Inc · Jacksonville, NCBuilt 1971 · S/N 28-7125454 N2144THilds Marine Service Inc · Pasadena, MDBuilt 1971 · S/N 28-7105166 N2146TBreitfelder Nicholas A · Durango, IABuilt 1971 · S/N 28-7125546 N2147TSchavone Loren A · Fullerton, CABuilt 1971 · S/N 28-7125547 N214AALewis University · Romeoville, ILS/N 28-4735 N214GSStephens Mark · Cullman, ALBuilt 1972 · S/N 28-7205138 N2150RChalkley Benjamin G · North Liberty, IABuilt 1969 · S/N 28-5471 N2150TBecker Brian C · Fort Dodge, IABuilt 1971 · S/N 28-7105165 N2153TFit Services LLC · Gladwin, MIBuilt 1971 · S/N 28-7205003 N2154RSydenstricker Gregg Scott · Toughkenamon, PABuilt 1969 · S/N 28-5472 N2155TFeltmeyer Rita Suzanne · Foley, ALBuilt 1971 · S/N 28-7205005 N2156TJacksonville Navy Flying Club · Jacksonville, FLBuilt 1971 · S/N 28-7205006 N2160THughes Johnny D · Meridian, MSS/N 28-7205010 N2162REndthoff Wayne K · Beloit, WIBuilt 1969 · S/N 28-5474 N2162TVolantis LLC · West Fargo, NDBuilt 1971 · S/N 28-7205012 N2167TKissi Ernest · New Britain, CTBuilt 1971 · S/N 28-7205017 N2168TGlass Kelly R · Jonesborough, TNBuilt 1971 · S/N 28-7205018 N216SRRegistration Pending · Bulverde, TXRegistration pendingBuilt 1965 · S/N 28-2161 N2170RKotz Dennis M · North Augusta, SCBuilt 1970 · S/N 28-5753 N2170TClarksdale-Coahoma County Airport · Clarksdale, MSBuilt 1971 · S/N 28-7205020 N2171RLogan Lance P · Mc Alpin, FLBuilt 1969 · S/N 28-5476 N2171TBox Aviation Inc · Montgomery, ALBuilt 1971 · S/N 28-7205021 N2173TDitatus LLC · Cornville, AZBuilt 1971 · S/N 28-7205033 N2174RTurner Ryan J · Pittsburg, TXBuilt 1969 · S/N 28-5478 N2174TSmith Dustin E · Helena, ALBuilt 1971 · S/N 28-7205023 N2175TFlying Partners Of Venice LLC · Port Charlotte, FLBuilt 1971 · S/N 28-7205025 N2176TSteeplechase LLC · Medfield, MABuilt 1971 · S/N 28-7205034 N2177TRegistration Pending · Pine Mountain, GARegistration pending, pending cancellationBuilt 1971 · S/N 28-7205032 N2178TOrban John J · Dewitt, MIBuilt 1971 · S/N 28-7205035 N2179TKroeger William R · Plattsmouth, NEBuilt 1972 · S/N 28-7205024 N217AWHobart Aviation Inc · Akron, OHS/N 28-7125332 N217LMCanada Christopher W · Freeport, FLBuilt 1966 · S/N 28-21972 N2180RRoan Paul J · Clive, IABuilt 1969 · S/N 28-5479 N2180TDe Bella Richard M Sr · Blackwood, NJBuilt 1971 · S/N 28-7205027 N2181TAdk Flying Club Inc · Ballston Spa, NYBuilt 1971 · S/N 28-7205036 N2182TGabrick Steven J · Hickory Valley, TNS/N 28-7205037 N2183TSkies Unlimited LLC · Clinton Township, MIBuilt 1971 · S/N 28-7205026 N2184TFisher Global LLC · Conway, ARBuilt 1971 · S/N 28-7205028 N2186THutchins Christopher E · Venice, FLBuilt 1971 · S/N 28-7205038 N2187TRegistration Pending · Sioux Falls, SDRegistration pendingBuilt 1971 · S/N 28-7205039

Back to AD 96-10-01 R1