Registered aircraft · 20,481

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:84-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:84-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:84-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:84-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:84-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:84-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.

N6329BN6329b Flyingclub LLC · Farmington, MNBuilt 1957 · S/N 34229 N6329CUnited Indian Mission DBA · Tucson, AZBuilt 1977 · S/N U20603844 N6329YDiablo Aviation LLC · Pleasanton, CABuilt 1981 · S/N 21064339 N632AHWrasse Mark R · Rosholt, WIBuilt 1957 · S/N 34248 N632CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281521 N632ESArvidson Randall C · Brighton, MIBuilt 2004 · S/N 18281384 N632LLLinthicum Lane H · Bakersfield, CABuilt 1997 · S/N 18280026 N632MRNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282186 N632TKKentucky State Police · Frankfort, KYBuilt 2009 · S/N 18282188 N6330BGroup Therapy Enterprises Inc · Claremore, OKBuilt 1957 · S/N 34230 N6330CLos Angeles County Sheriffs Department · Long Beach, CABuilt 1980 · S/N 21063866 N6330DReliant Technologies Incorp · Port Allen, LABuilt 2008 · S/N 18282110 N6330FHansen Jodi L E · Farmington, MNBuilt 1975 · S/N 18264162 N6332ASkydive Awesome! LLC · Bend, ORBuilt 1956 · S/N 33132 N6332T32 Tango Aviation LLC · Beaverton, ORBuilt 1984 · S/N R18201984 N63336Murry John · Anchorage, AKBuilt 1977 · S/N 18052841 N6333AHeller Peter C · Denver, COBuilt 1956 · S/N 33133 N6333BEspiricueta William L · Denver, COS/N 34233 N6333EProstar Flight Services LLC · Bozeman, MTBuilt 1983 · S/N 18268359 N6334BS&D Spraying Service Inc · Panhandle, TXBuilt 1957 · S/N 34234 N6334WColwell Kevin · Middleton, WIBuilt 2008 · S/N 18282108 N6335ZLs Express LLC · Syosset, NYBuilt 2008 · S/N 18282128 N63368Lorenzen Kraig Elmer · Pagosa Springs, COBuilt 1977 · S/N 18052842 N6336BNorris Donald A III · Edmond, OKBuilt 1957 · S/N 34236 N6336UBravo Whiskey LLC · Missoula, MTBuilt 1985 · S/N 21064937 N6337AAilf Marketing LLC · Port Charlotte, FLS/N 33137 N6337BMckee Bradley Cole · Taylor, TXBuilt 1957 · S/N 34237 N6337KK-Ville Flyers LLC · Newmanstown, PABuilt 2008 · S/N 18282135 N6338ALittle Bird Airways LLC · Hamburg, NYBuilt 1956 · S/N 33138 N6338BSlad George W · Albuquerque, NMBuilt 1957 · S/N 34238 N6339AHockenberry Tyler F · Royse City, TXBuilt 1956 · S/N 33139 N6339CBowles Donald E Jr · Dallas, TXBuilt 1980 · S/N 21063871 N633CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281528 N6340FCommonwealth Of Massachusetts · Plymouth, MABuilt 1975 · S/N 18264165 N6341APattison Jeffrey L · Glasgow, MTS/N 33141 N6341FChronister Rex · Fort Smith, ARBuilt 1975 · S/N 18264166 N6342YFdxp Inc · High Point, NCS/N 21064342 N63430Marr Brandon J · Monmouth, ORS/N 18052845 N6344AAvery Timothy · Payette, IDBuilt 1956 · S/N 33144 N6344BJerome Buying Station Inc · Jerome, IDS/N 34244 N6344YCole William G · Garner, NCBuilt 1981 · S/N 21064344 N63458Fowler Ron · Lopez Island, WAS/N 18052847 N6345AMoss Gary · Bend, ORBuilt 1956 · S/N 33145 N6345DRumble Aviation LLC · Thomasville, GABuilt 2004 · S/N 18281401 N6345ZAerial Transport LLC · Dover, DEBuilt 1981 · S/N U20606246 N63461Georgia Golf Cars Inc · Douglas, GABuilt 2004 · S/N 18281402 N6346ASkydive Operator Aircraft Rentals LLC · Ithaca, NYBuilt 1956 · S/N 33146 N6346BEasley John C · Eagle Rock, MOBuilt 1957 · S/N 34246 N6346ERudd Richard L · Cornelius, NCBuilt 2008 · S/N 18282144 N6346TNemec Jeffery W · Bowling Green, KYBuilt 1984 · S/N R18201989

Back to AD 84-10-01 R1