Registered aircraft · 26,232

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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.

N7559MPatton Steven W · Fayetteville, ARBuilt 1959 · S/N 55859 N7559UFreeman Jet LLC · Cape Coral, FLBuilt 1975 · S/N 15077736 N7560GGreen Carl S · Crivitz, WIS/N 15074699 N7560MShenk Mike D · Harper, ORBuilt 1959 · S/N 55860 N7560TKaplan Paula A · Yorba Linda, CABuilt 1959 · S/N 47160 N7560XCrew Gerald · Edna Bay, AKBuilt 1960 · S/N 17248060 N7561BWilkinson Charles F · Maiden, NCBuilt 1957 · S/N 7FC-63 N7561THendrickson David S · Hamptonville, NCS/N 47161 N7562CGraziano Thomas K · Benson, AZBuilt 1959 · S/N 5679 N7562TDupree Thomas J · Saranac Lake, NYBuilt 1959 · S/N 47162 N7563CQuandt Richard L · South Sioux City, NES/N 5680 N7563THaslam Jim M · Twain Harte, CABuilt 1959 · S/N 47163 N7563XLogan Zachary R · Stamford, TXBuilt 1960 · S/N 17248063 N7564BHegel Tina Elizabeth · Bonney Lake, WABuilt 1957 · S/N 7FC-66 N7564MAbkc LLC · Newark, DEBuilt 1959 · S/N 55864 N7564TRegistration Pending · Phoenix, AZRegistration pendingBuilt 1959 · S/N 47164 N7564USabatowich Erik J · Detroit, MIBuilt 1975 · S/N 15077740 N7564XSodah One LLC · San Ramon, CAS/N 17248064 N7565ESouthworth Grant J · Bloomer, WIBuilt 1958 · S/N 7FC-259 N7565MLeaver Bros · Rossville, ILFirst renewal noticeBuilt 1959 · S/N 55865 N7566CAnton Paul M · Salome, AZBuilt 1959 · S/N 5683 N7566EBeausoleil-Holt Alyson L · Jackson, NJBuilt 1958 · S/N 7FC-260 N7566TMerritt Joseph P · Pryor, OKS/N 47166 N7566XKeenan Drew P · Chico, CABuilt 1960 · S/N 17248066 N7567BWasson Tom L · Lakeport, CAS/N 68 N7567CVorpe Thomas · Pearland, TXBuilt 1959 · S/N 5684 N7567EWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1958 · S/N 7EC-679 N7568CSmundin George · Munster, INBuilt 1959 · S/N 5685 N7568ETaylor Robert S · Ivoryton, CTS/N 7FC-261 N7568XKrassovsky Viatcheslav · Berkeley, CABuilt 1960 · S/N 17248068 N7569CBellamy John Mark · Savannah, NYBuilt 1959 · S/N 5686 N7569EPaul Mark A · Warren, OHBuilt 1958 · S/N 7FC-263 N7569THuddleston Garry W · Brownstown, MIBuilt 1959 · S/N 47169 N75708Snamiske John G · Madison, WIS/N 13296 N7570CShackelford Jeffrey A · Morris, ILBuilt 1959 · S/N 5687 N7570EOgan Jerald · Pierre, SDBuilt 1958 · S/N 7FC-262 N7570MBarreto Brian C · Lebanon, ORFirst renewal noticeBuilt 1959 · S/N 55870 N7570XJones Frank E · Merritt Island, FLBuilt 1960 · S/N 17248070 N7571BSterling C Bain Jr · Alexandria, LABuilt 1957 · S/N 7FC-76 N7571CEastland Walter J · Frankston, TXBuilt 1959 · S/N 5688 N7571XBrown Bomber Aviation LLC · Little Rock, ARS/N 17248071 N7572TFlying Colors Airparts Inc · Leesburg, FLBuilt 1959 · S/N 47172 N7572UAirfrank Inc · Hackensack, NJBuilt 1975 · S/N 15077741 N7573CReynolds Terry · Phoenix, AZBuilt 1959 · S/N 5690 N7573MToledo Oscar · North Bergen, NJBuilt 1958 · S/N 55873 N7573TBogard Aviation LLC · Milan, MOBuilt 1959 · S/N 47173 N7574MStanphill Archie R · Lonoke, ARS/N 55874 N7574TWells David M · Weatherford, TXBuilt 1959 · S/N 47174 N7574XParker Air LLC · Corinth, MSBuilt 1960 · S/N 17248074 N7575BKeown William Joshua · Calhoun, GAS/N 7FC-78

Back to AD 94-05-05 R1