Skip to content

Registered aircraft · 8,139

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.

N4517TTate Levi W · Saint George, UTBuilt 1972 · S/N 28-7205177 N4518REdmondson William A · Rosamond, CAFirst renewal noticeBuilt 1965 · S/N 28-21220 N451BTNeosho Investments LLC · Neosho, MOBuilt 1967 · S/N 28-23951 N4520QShumate Jeff · Park City, UTS/N 28-7725237 N4520RBurge John A · Pensacola, FLS/N 28-21222 N4520TBrummell Colten Andrew · Hannibal, MOBuilt 1971 · S/N 28-7105216 N4521RLenz Gregory K · Everton, MOBuilt 1965 · S/N 28-21223 N4523RGardner Michael J · Ashland, ILS/N 28-21225 N4525RFreiberg Industries Inc · State Center, IAFirst renewal noticeBuilt 1965 · S/N 28-21228 N4526RGulledge Richard · Deland, FLBuilt 1965 · S/N 28-21229 N4526XGeorge Barbara A · Carlisle, PABuilt 1975 · S/N 28-7625049 N4527RGmk Aviation LLC · Brighton, MIBuilt 1965 · S/N 28-21230 N4528RPhilbrick William E · Virginia Beach, VABuilt 1965 · S/N 28-21231 N4529RSulzby Ivan Gerardo · Las Vegas, NVBuilt 1965 · S/N 28-21232 N4530TKoprivnik Anton J · Painesville, OHS/N 287225181 N4532RWherley Matthew J · Plato, MNBuilt 1965 · S/N 28-21236 N4534RDuwelius Charlotte Sue DBA · Hermiston, ORBuilt 1965 · S/N 28-21238 N4535TCrews Joseph G · Cleveland, MSBuilt 1971 · S/N 28-7105222 N4536RRoesler Robert D · Gordonsville, VABuilt 1965 · S/N 28-21240 N4537TRussell Brice S · Milton, MABuilt 1971 · S/N 28-7105229 N4538TLarsen Jeffrey A · Spokane Valley, WABuilt 1972 · S/N 28-7205190 N4538XHicks Paul · Greenfield Center, NYBuilt 1975 · S/N 28-7625051 N4540RCase Herbert P · Wendell, NCS/N 28-21245 N4540TMurray Clifford K · Brunswick, GABuilt 1972 · S/N 28-7205181 N4541RBaker William D · Hyannis, NEBuilt 1965 · S/N 28-21246 N4542RBlue Skies Flying Club LLC · Painesville, OHBuilt 1965 · S/N 28-21247 N4543TNichols Curtis · Gloucester, VABuilt 1972 · S/N 28-7225183 N4546RDr Se Flight Services LLC · Kansas City, MOBuilt 1965 · S/N 28-21252 N4547RYeattes Michael K · Emporia, VABuilt 1965 · S/N 28-21253 N4549RHamburg Airport 1 LLC · Williamsville, NYBuilt 1965 · S/N 28-21255 N454CFlorida Coastal Flying Club LLC · Titusville, FLBuilt 1967 · S/N 28-23412 N454MDRegistration Pending · Bulverde, TXRegistration pendingBuilt 1966 · S/N 28-3125 N4550XAltitude LLC · Madison, WIBuilt 1975 · S/N 28-7625053 N4554TGlazer Aviation LLC · Owings Mills, MDBuilt 1972 · S/N 28-7205184 N4555REagle Aeronautical Company LLC · Dover, DEBuilt 1965 · S/N 28-21294 N4557RThomson James A · Boron, CABuilt 1965 · S/N 28-21298 N4557TWomack Associates LLC · Lancaster, KYBuilt 1972 · S/N 28-7225188 N4558RMorgan Chad A · Sarepta, LABuilt 1965 · S/N 28-21300 N4559RCavu Flight LLC · Simpsonville, SCS/N 28-21301 N4559TLeek Aviation LLC · Wilmington, DEBuilt 1972 · S/N 28-7205185 N455FLFisher Jeffrey D · Omaha, NEBuilt 1971 · S/N 28-7125250 N4561XAir Bhnb LLC · Statesboro, GAS/N 28-7625055 N4562RMcclure Richard A · Victoria, TXS/N 28-21304 N4562TSellers Kelly A · Crossville, TNS/N 28-7205186 N4565FHughey Charles A Jr · Oak Ridge, TNBuilt 1976 · S/N 28-7725022 N4565RHenderson Javier · Raleigh, NCS/N 28-21308 N4566FMarcum Timothy T · Waddy, KYBuilt 1976 · S/N 28-7725023 N4566RMedia Stew LLC · Carson City, NVBuilt 1965 · S/N 28-21309 N4568RChuss Edward J · Metamora, MIBuilt 1965 · S/N 28-21326 N4569RNoco Flying Club LLC · Fort Collins, COBuilt 1966 · S/N 28-21310

Back to AD 96-10-01 R1