Registered aircraft · 20,483

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.

N4773SSonrex LLC · Auburn, INBuilt 1979 · S/N R18201423 N4773THagerman John · Coxs Creek, KYBuilt 1981 · S/N R18201761 N4773UFins Fur & Feathers Flying LLC · King Salmon, AKBuilt 1979 · S/N U20605094 N4774BCunningham Martin Alden · Kansas City, MOBuilt 1955 · S/N 31672 N4775BChavez Edward C · Boise, IDBuilt 1955 · S/N 31673 N4775NTennessee Metals Recycling LLC · Murray, KYBuilt 1979 · S/N 18267358 N4775UBishop Mike · Rifle, COBuilt 1964 · S/N 18051475 N4776BLarsen Christopher F · Fairbanks, AKBuilt 1955 · S/N 31674 N4776NRegistration Pending · Ceiba, PRRegistration pendingBuilt 1979 · S/N 18267359 N4776THigh Planes Air Service · Bismarck, NDBuilt 1981 · S/N R18201762 N4776UHabberstad John L · Rathdrum, IDBuilt 1979 · S/N U20605096 N4777NRosario Edwin A · Pine Island, NYBuilt 1979 · S/N 18267360 N4777UAdair Aviation LLC · Broken Arrow, OKBuilt 1983 · S/N 21064814 N4778FPond Engineering Laboratories Inc · Berthoud, COBuilt 1967 · S/N P206-0378 N4779TAmerican Aerial Patrol LLC · Saint Amant, LABuilt 1981 · S/N R18201764 N4779UBergh Eugene H · Roberts, WIBuilt 1964 · S/N 18051479 N477GFState Of Alabama Department Of Conservation · Montgomery, ALBuilt 2018 · S/N 18283055 N477GYGolf Yankee LLC · Haymarket, VABuilt 2024 · S/N 18283265 N477MAThompson Layne A · Pollok, TXBuilt 1981 · S/N 21064291 N4781DGipe Douglas A · Malvern, IABuilt 1958 · S/N 34881 N4781NRobwin Air LLC · Lutz, FLBuilt 1979 · S/N 18267364 N4782DSwalling Matthew C · Wasilla, AKBuilt 1958 · S/N 34882 N4783BRogge Gary L · Fowler, COBuilt 1955 · S/N 31681 N4783NPlane Sense LLC · Oregon City, ORBuilt 1979 · S/N 18267366 N4784BPhyfe Andrew L · Cape Coral, FLBuilt 1955 · S/N 31682 N4784FSullivan Ross Anthony · Saint Helena, CAS/N P206-0384 N4785NHolden Engineering Inc · Oviedo, FLBuilt 1979 · S/N 18267368 N4785UNew England Vascular Access LLC · Bristol, NHBuilt 1983 · S/N 21064816 N4786DPierce Stephan L · Graham, TXBuilt 1958 · S/N 34886 N4786FLogan Robert E · Advance, NCBuilt 1968 · S/N P206-0470 N4786SMultiprop Ventures LLC · Danvers, MABuilt 1979 · S/N R18201427 N4787SClassic Image Auto LLC · Huntsville, ALS/N R18201428 N4787UDreyer Jeffrey J · Payson, AZBuilt 1964 · S/N 18051487 N4789FGrimes Aero LLC · Hobbs, NMBuilt 1967 · S/N P206-0389 N4789NRegistered aircraftBuilt 1980 · S/N 18267409 N478ACModern Mobility LLC · Kennedale, TXBuilt 2024 · S/N 18283272 N478GPGypsy Aviation LLC · Hattiesburg, MSBuilt 2005 · S/N 18281523 N478KJBw182t LLC · Ocean City, MDBuilt 2021 · S/N 18283140 N478KNKunes Kimberly A · Westport, WABuilt 2023 · S/N 18283227 N478MCDouble Eagle Air LLC · Searcy, ARBuilt 2005 · S/N 18281578 N4790BKringle Wendell K · Barron, WIBuilt 1955 · S/N 31688 N4790DGlobal Navigator LLC · Anacortes, WAS/N 34890 N4790FKise Scott T · Circle Pines, MNBuilt 1967 · S/N P206-0390 N4790ZBem Holdings LLC · Dover, DEBuilt 1974 · S/N 20700240 N4791DBoan Randall P · Milton, IABuilt 1958 · S/N 34891 N4791FPfp Aviators LLC · South Salt Lake, UTBuilt 1967 · S/N P206-0391 N4791UAerialtraders LLC · Fort Myers, FLBuilt 1979 · S/N U20605104 N4792UWegman Atlas George · Ghent, NYBuilt 1964 · S/N 18051492 N4794FGet Out Aviation LLC · Palmer, AKBuilt 1967 · S/N P206-0394 N4795CPrecision Design Inc · Wilmington, DEBuilt 1979 · S/N 21063629

Back to AD 84-10-01 R1