Registered aircraft · 81,733

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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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:81-18-04-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
  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:81-18-04-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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.

N507DTThomas Mark R · Clintondale, NYBuilt 1982 · S/N 6803K-386 N507EFFreitag Ernst · Concord, CABuilt 2011 · S/N 40513 N507EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12858 N507FH 507 LLC · Austin, TXBuilt 2007 · S/N 2398 N507FLSpence Ryan · Chicopee, MABuilt 1971 · S/N 28-7125328 N507GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881179 N507GBCountry Cabinet Shop Inc · Benton, KSFirst renewal noticeBuilt 2005 · S/N 593-320-340FB N507GLSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1974 · S/N 507 N507JLLara Jess D · Albuquerque, NMBuilt 2007 · S/N 557 N507JMMagdaleno Joseph M II · Reno, NVBuilt 1990 · S/N 1 N507JPShrike Comm LLC · Matthews, NCBuilt 1976 · S/N 3262 N507LAColumbia Leasing LLC · Hillsboro, ORBuilt 2024 · S/N 172S13123 N507LSLansing Community College · Mason, MIBuilt 1983 · S/N ALS001A N507MMLedger Willaim V Jr · Shreveport, LAS/N RW001 N507PHocker Matthew Tutt · LondonBuilt 2001 · S/N 18281008 N507RGMccurdy Paul R · North Falmouth, MABuilt 1995 · S/N 2507 N507RHJones Douglas H · Prather, CABuilt 1993 · S/N 20200 N507SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881421 N507THLeyva Maria · Edgewater, FLBuilt 1971 · S/N 34-7250037 N5080WMatzke Kevin T · Gilbert, AZBuilt 1961 · S/N 28-89 N5080XOber John A · Candor, NYBuilt 1968 · S/N 143 N5080ZBrazil Joshua B · Omaha, NEBuilt 1961 · S/N 22-8711 N5081SDream Factory Aviation Inc · Henderson, NVBuilt 1971 · S/N 28R-7135081 N5081UKiloecho Aeronautics LLC · Tucson, AZBuilt 1971 · S/N 17259673 N5081VWalker Gregory S · Gypsum, COBuilt 1977 · S/N VAC-70-77 N5081YDoumis Joy S · Marathon, FLBuilt 1962 · S/N 27-2099 N5081ZTech Mobile LLC · New Windsor, MDBuilt 1961 · S/N 22-8712 N50822Nyhus Sharon L · Harvey, NDBuilt 1980 · S/N 17274221 N50826Bristol Bay Capital LLC · Watkins, COS/N 17274222 N5082GJala Tech Services LLC · Social Circle, GABuilt 1979 · S/N 17273531 N5082PShaw Jeryl V · Arcata, CABuilt 1958 · S/N 24-88 N5082RWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17263320 N5082VMorton John W · El Segundo, CABuilt 1977 · S/N VAC-71-77 N5082WAmeeti Robert Keith Trustee · Newport Beach, CABuilt 2001 · S/N 172S8970 N5082YTanner Greg · Bend, ORBuilt 1962 · S/N 27-2100 N5082ZHuddleston Anthony A · Knoxville, TNBuilt 1961 · S/N 22-8713 N50838Ansee LLC · Seattle, WABuilt 1980 · S/N 17274224 N5083CTsf Inc · Bristol, WIBuilt 1980 · S/N R18201555 N5083KLoewen Wielhelm N · Presidio, TXBuilt 1980 · S/N 17273956 N5083SRiser Air LLC · Stillwater, MNBuilt 1971 · S/N 28R-7135082 N5083VBarth Charles L · Pekin, ILBuilt 1977 · S/N VAC72-77 N5083XFlytails LLC · Pace, MSFirst renewal noticeBuilt 1968 · S/N 155 N5083ZMorell Patrick J · Byron Center, MIBuilt 1961 · S/N 22-8714 N5084MFabrizio Timothy · Oswego, ILBuilt 1978 · S/N MC-571 N5084RBenham Eric T · Las Vegas, NVBuilt 1974 · S/N 17263322 N5084WShouse Robert G · Owasso, OKBuilt 1961 · S/N 28-93 N50854Fulton Lanny G · Spartanburg, SCBuilt 1968 · S/N 15069600 N50858Christiansen Aviation LLC · Wilmington, DEBuilt 2009 · S/N 172S10894 N5085BAccelerated Aviation Instruction LLC · Owatonna, MNBuilt 1979 · S/N 15283739 N5085KMartin Bach Aviation LLC · Cornelius, NCBuilt 1980 · S/N 17273957

Back to AD 81-18-04 R2