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.

N9606BAnderson David R · Sycamore, ILBuilt 1957 · S/N 32903 N9606XRowland Douglas · Wichita, KSS/N 21057906 N9607XBaldridge Steven J · Edmonds, WAS/N 21057907 N9607YIsn Aviation LLC · Loup City, NEBuilt 1981 · S/N 21064559 N9608GCopper River Airmotive LLC · Copper Center, AKBuilt 1972 · S/N U20601808 N9608XEsdaile Philip J · Woodland, CABuilt 1962 · S/N 21057908 N960CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281990 N9610GChoice Aviation LLC · Hamilton, MTBuilt 1972 · S/N U20601810 N9610TMulkey Randall L · Wellston, OKBuilt 1960 · S/N 57410 N9610XSutton George E · Fullerton, CABuilt 1961 · S/N 21057910 N9611HTarheel Aviators LLC · Cary, NCBuilt 1981 · S/N 18267972 N9611XWinston Air LLC · Haleyville, ALS/N 21057911 N9612G4-F Flyers LLC · Haysville, KSBuilt 1974 · S/N 18263408 N9612RBearnose II LLC · Edina, MNBuilt 1985 · S/N U20606901 N9613BLiebsch Mark W · Reno, NVBuilt 1957 · S/N 32910 N9613GDavid W Easter Consulting Inc · Libby, MTBuilt 1972 · S/N U20601813 N9613TMilleman Barry M · Monticello, INBuilt 1960 · S/N 57413 N9613ZAlosanel Charter Inc · Concord, NHFirst renewal noticeS/N U20606575 N9614KPassmore Stephen B · Lacrosse, WABuilt 1983 · S/N T18803962T N9614TLucas Lester L · Napa, CABuilt 1960 · S/N 57414 N9614XMountain Air Flying LLC · Brigham City, UTBuilt 1962 · S/N 21057914 N9616ELove James H · Springville, ALBuilt 1984 · S/N 18268429 N9616XJim Barrett Photography Inc · Honolulu, HIBuilt 1961 · S/N 21057916 N9617ZWright William F Trustee · Anchorage, AKS/N U20606578 N9618GH&M Ltd · Warren, IDS/N 18263409 N9619EHofer Terril D · Maple Grove, MNBuilt 1984 · S/N 18268430 N961ERCoyote Air LLC · Hermiston, ORBuilt 1979 · S/N 18266923 N961WSWalt Schwartz Aviation LLC · Louisville, KYBuilt 1985 · S/N 18268462 N9620EJones Benjamin J · Little Rock, ARBuilt 1984 · S/N 18268431 N9621BLee Gerald R · Glennallen, AKBuilt 1957 · S/N 32918 N9621TJ D Kraemer Enterprises LLC · Fargo, NDS/N 57421 N9622BSmith Glenn R · Palmer, AKBuilt 1957 · S/N 32919 N9623RUnited States Department Of Interior · Boise, IDBuilt 1985 · S/N U20606906 N9624EA & I Aviator Investments LLC · La Habra, CABuilt 1984 · S/N 18268432 N9626GFly 2 Crp LLC · Cleveland, TXBuilt 1972 · S/N U20601826 N9626XPortman Joe · Elmendorf, TXBuilt 1962 · S/N 21057926 N9627XW J Bolton Farms LLC · Marked Tree, ARBuilt 1962 · S/N 21057927 N9628BBryan Kirk J · Big Timber, MTBuilt 1957 · S/N 32925 N9628GNicols Bruce D · Titusville, PABuilt 1974 · S/N 18263410 N9629BVisser Ag Inc · Rigby, IDBuilt 1957 · S/N 32926 N9629TBramlett Russell · Winder, GABuilt 1960 · S/N 57429 N962CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281972 N962JBNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282149 N962PBNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282159 N962RGBoucher John C · Lakeside, AZBuilt 1967 · S/N U206-0957 N9630TBridgford Bruce H · Anaheim, CABuilt 1960 · S/N 57430 N9630XSea-S-Ta Aviation LLC · Alexandria, VABuilt 1986 · S/N 18268568 N9632BDbstd LLC · Nickerson, NEBuilt 1957 · S/N 32929 N9632ZAngelone Inc · Elkhart, INS/N U20606585 N9633XCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 18268570

Back to AD 84-10-01 R1