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.

N7551ZKustatan Leasing LLC · Kenai, AKS/N U20606365 N7553KRichardson Richard E II · Windham, MEBuilt 1976 · S/N 18052673 N7553SFarrell David A · Milton, WIBuilt 1976 · S/N 18265202 N7554SHeard Charles R · Dothan, ALBuilt 1976 · S/N 18265203 N7555HInteraero Inc · Westlake Village, CABuilt 1981 · S/N 18267916 N7556NSmith Chad R · West Plains, MOBuilt 1974 · S/N 18263245 N7556SReedm LLC · Little Rock, ARBuilt 1976 · S/N 18265205 N7557SBooher Travis J · Missoula, MTS/N 18265206 N7557TArizona Flyers Club Inc · Tucson, AZBuilt 1977 · S/N R18200038 N7557XWright Aero Inc · Saint Cloud, MNBuilt 1977 · S/N R18200099 N7558NRegistration Pending · Benton, ARRegistration pendingBuilt 1974 · S/N 18263247 N7558SUbarri Luis M · Caguas, PRBuilt 1976 · S/N 18265207 N7559SSand John · Albany, MNBuilt 1976 · S/N 18265208 N755CCStik LLC · Batesville, ARBuilt 1976 · S/N 18265201 N755CMCluster Fish LLC · Charleston, SCBuilt 1980 · S/N 21063934 N755HBBrown William Henry · Ravenna, TXBuilt 1979 · S/N 18053018 N755MCCisneros Joe M · Nashville, TNBuilt 1983 · S/N R18201959 N755SWMelendez Daniel Alexan · Yuma, AZBuilt 1975 · S/N 21060965 N755TGInverted Aviation LLC · Atascadero, CABuilt 1977 · S/N 18265666 N755WUsda Forest Service Fepp · Malvern, ARBuilt 1958 · S/N 50252 N7560KAlbert Bryan Wayne · Palmer, AKBuilt 1976 · S/N 18052676 N7561NPierce County Sheriffs Department · South Hill, WABuilt 1977 · S/N U20603673 N7561SQuality Fliers LLC · Kennewick, WABuilt 1976 · S/N 18265210 N7561XNri Flying Club Inc · Walnut Creek, CABuilt 1977 · S/N R18200101 N7562SSnowridge LLC · Marysville, OHBuilt 1976 · S/N 18265211 N7563SRusso Robert A · Chicago, ILBuilt 1976 · S/N 18265212 N7565SExplore Air LLC · Kalispell, MTBuilt 1976 · S/N 18265214 N7565XDonaldson Bros Flying Circus LLC · Spencer, IABuilt 1977 · S/N R18200103 N7566NBoedecker Brock · Sheridan, WYBuilt 1974 · S/N 18263255 N7566SK7 Air LLC · Blanding, UTBuilt 1976 · S/N 18265215 N7567QJolley Joseph J · Anchorage, AKBuilt 1978 · S/N U20604275 N7568270 North LLC · Anchorage, AKBuilt 1980 · S/N 20700638 N7568HEnergy Transfer Aviation LLC · Spring, TXS/N 18267917 N7568MPeters William R · Naperville, ILBuilt 1977 · S/N 21062021 N7568SAero Plus LLC · Thermopolis, WYBuilt 1976 · S/N 18265217 N7568TSale Reported · Phoenix, AZSale reportedBuilt 1977 · S/N R18200039 N7568YAviation Associates LLC · Oxford, MDBuilt 1977 · S/N R18200137 N7569NArctic Aviation Leasing LLC · Anchorage, AKBuilt 1977 · S/N U20603679 N7569SEnginaires Aero Club Inc · Savoy, ILBuilt 1976 · S/N 18265218 N756AHKincaid Linda C · North Pole, AKBuilt 1977 · S/N U20603932 N756ANJelinek Tyson · Iola, KSBuilt 1977 · S/N U20603937 N756ARTehama Angus Ranch Inc · Gerber, CAS/N R18201024 N756AVSmith Air LLC · Cascade, IDBuilt 1977 · S/N U20603944 N756BBCampbell Steven P · Annapolis, CABuilt 1977 · S/N U20603950 N756BCBuchanan Bryan DBA · Gig Harbor, WABuilt 1979 · S/N R18201028 N756BNBeck Skydiving & Rigging LLC · Bixby, OKBuilt 1977 · S/N U20603961 N756BYW Yerxa LLC · Colusa, CAS/N U20603971 N756CLEgli Sam · King Salmon, AKBuilt 1977 · S/N U20603983 N756CRConnell Donna M · Belton, TXBuilt 1977 · S/N U20603988 N756CTKamlowsky Scott A · Anchorage, AKBuilt 1977 · S/N U20603990

Back to AD 84-10-01 R1