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.

N5132SFightin Fourth Line Pilots LLC · Gig Harbor, WABuilt 1971 · S/N 28-7105176 N5132ULiberty Exploration Inc · Las Vegas, NVS/N 172RG0250 N5132VFord Lynn W · Gibsonia, PABuilt 1961 · S/N SP-28 N5132WSmith Dale S · Grass Valley, CABuilt 1961 · S/N 28-161 N5132XLinch Travis R · Belle Fourche, SDS/N 147 N5133Small Gaston Elvin III · Elizabeth City, NCBuilt 1968 · S/N 1010 N51330Cortez Flying Service Inc · Cortez, COBuilt 1980 · S/N 17274298 N5133GPioneer Aviation LLC · Crossett, ARBuilt 1969 · S/N 17258447 N5133HBlydenburgh Daniel R · Palmer, AKBuilt 1948 · S/N 14-144 N5133KAa-Aero Inc · Fairfield, NJBuilt 2001 · S/N 172S9002 N5133LBiederman Clifton E · Jasper, FLBuilt 1967 · S/N 28-4416 N5133PMoore Buck B · Wasco, CABuilt 1958 · S/N 24-146 N5133QReed Aero Group LLC · Hendersonville, TNBuilt 1973 · S/N 17261761 N5133SMcclelland Kip · Douglas, GABuilt 1971 · S/N 28-7105177 N5133TRanspot Richard P · Burlington, TXBuilt 1966 · S/N 76 N5133VFlying Monkey LLC · Wilmington, DEBuilt 1961 · S/N SP-29 N5134Ireland James L · Fort Worth, TXFirst renewal noticeBuilt 1970 · S/N 32520 N5134GRegistration Pending · Cannon Falls, MNRegistration pending, pending cancellationBuilt 1969 · S/N 17258448 N5134HSquier John F · North Yarmouth, MEBuilt 1948 · S/N 14-143 N5134LPmd Services LLC · Wilmington, DEBuilt 1967 · S/N 28-4417 N5134TLawrence David Denton · Roanoke, VABuilt 1966 · S/N 75 N5135ECommercial Safe And Lock Inc · Imperial, MOBuilt 1978 · S/N 17271728 N5135GChinrock Adam · Spanish Fort, ALBuilt 1969 · S/N 17258449 N5135HKinneen Simon N · Nome, AKBuilt 1948 · S/N 14-145 N5135LBolden Robert P · Uvalda, GABuilt 1967 · S/N 28-4418 N5135PChristiansen Aviation LLC · Wilmington, DEBuilt 2009 · S/N 172S10936 N5135SThompson Eric H · Tucson, AZBuilt 1971 · S/N 28-7125467 N5135TRayl Benjamin E · Mason City, IAS/N 562 N5135VLochner Richard A · Eagle River, AKBuilt 1961 · S/N SP-31 N51362Caputi J Gary · Mashpee, MABuilt 2001 · S/N 172S9010 N5136CMonadnock Aviation Inc · Keene, NHBuilt 2002 · S/N 172S9150 N5136DZieg James E · Goldsboro, NCBuilt 1979 · S/N 17272432 N5136EWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17271729 N5136GYork Aviators LLC · York, PAS/N 17258450 N5136HMerrill Jerry R · Willow, AKBuilt 1948 · S/N 14-146 N5136LBerkowitz Bruce · Poughkeepsie, NYBuilt 1967 · S/N 28-4419 N5136PDunn James F · Salem, INBuilt 1958 · S/N 24-150 N5136UNg Raymond Fong · New York, NYBuilt 1980 · S/N 172RG0252 N5136WGreen Patric S · Stillwater, OKBuilt 1961 · S/N 28-165 N51379N51379 LLC · Galena, OHBuilt 1974 · S/N 17264235 N5137HKingdom Air Corps · Sutton, AKS/N 14-147 N5137LSky Vector LLC · Rustburg, VABuilt 1967 · S/N 28-4421 N5137MFuture Pilots Of America Flight Academy LLC · Baxley, GABuilt 1978 · S/N MB-890 N5137PFrancis Himanshu Raj · Blythewood, SCBuilt 1958 · S/N 24-151 N5137RSchmeelk Darrin D · Thompson, CTBuilt 1974 · S/N 17263354 N5137VBurns Mark G · Anacortes, WABuilt 1962 · S/N SP33 N5137WKrehbiel Timothy M · Holt, MOBuilt 1961 · S/N 28-166 N5137ZHill Glenn · Belle Mead, NJBuilt 1962 · S/N 22-9431 N51380Aircraft Leasing Inc · Everett, WABuilt 1980 · S/N 17274305 N51386Russell Joseph M J · Douglas, WYBuilt 1977 · S/N 177RG1138

Back to AD 81-18-04 R2