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.

N4861GFlying Colors Airparts Inc · Leesburg, FLBuilt 1979 · S/N 17273408 N4861LPodolinski Frank · Greensburg, PABuilt 1967 · S/N 28-4213 N4861SMidwest Airmotive Inc · Mount Sterling, KYBuilt 1979 · S/N R18201439 N4861VRegistered aircraftBuilt 1980 · S/N 172RG0403 N4862ASmith James A · Lyle, WABuilt 1951 · S/N 22-279 N4862LGunter Gordon D · Green River, WYBuilt 1968 · S/N 28-4216 N4862YKohler Richard L · Moriarty, NMBuilt 1968 · S/N 25-4665 N48637K S Aviation · Atwater, CABuilt 1977 · S/N 15280924 N4863ARud Alexandra E · Clara City, MNBuilt 1956 · S/N 22-4022 N4863LZimmerman Marlin · Muscoda, WIBuilt 1967 · S/N 28-4217 N4863SHogs LLC · Georgetown, SCBuilt 1970 · S/N 32-1290 N4863TM & M Light Transportation Co Inc · Duluth, MNBuilt 1981 · S/N R18201778 N4863ZIvy James H III · Seligman, AZBuilt 1961 · S/N 22-8439 N4864DChiota Aviation LLC · Waco, TXFirst renewal noticeBuilt 1979 · S/N 17272377 N4864FFreely James John · Marshall, VAS/N 28-7790069 N4864GLazy Eights Holdings LLC · Greenwood, INBuilt 1979 · S/N 17273411 N4864LRegistration Pending · Boone, NCRegistration pendingBuilt 1967 · S/N 28-4218 N48650Herion Chris W · Williamsburg, VABuilt 1977 · S/N 15280926 N48652Lorenz John C · Edgewood, NMBuilt 1943 · S/N 135 N4865DBlack Hound Aviation LLC · Austin, TXS/N 17273904 N4865SBowman Steven R · Manteo, NCBuilt 1970 · S/N 32-1296 N4865ZSchroer Steven K · Columbus, INBuilt 1961 · S/N 22-8442 N4866ECollier Charles R · Gloucester, VABuilt 1959 · S/N 7GC51 N4867DFlynn Brian · Auburndale, FLBuilt 1979 · S/N 17272378 N4867L23 Right LLC · Kalispell, MTBuilt 1967 · S/N 28-4221 N4868EVero Technical Support Inc · Pensacola, FLBuilt 1978 · S/N 17271671 N4868LWinningham Matthew P · Prattville, ALBuilt 1968 · S/N 28-5123 N4868VKusy Edward James · Schulenburg, TXS/N 536 N48690Chamberlin William C · Williamsburg, MIBuilt 1977 · S/N 15280929 N4869ANevill Bernard L · Clare, MIBuilt 1956 · S/N 22-4029 N4869LCentral Texas College · Killeen, TXBuilt 1980 · S/N 15284237 N486BLBlue Line Aviation LLC · Smithfield, NCBuilt 2024 · S/N 2881786 N486CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 18283302 N486CBCalifornia Baptist University · Riverside, CABuilt 2018 · S/N 4496417 N486CPCivil Air Patrol · Montgomery, ALBuilt 2010 · S/N 18282261 N486DMMoes Sarah J · Rossford, OHS/N 32-286 N486EMMason Edward R Trustee · Wilsonville, ORS/N 001 N486FLBaker Donnie · Christiana, TNBuilt 1971 · S/N 28-7125295 N486JWWade James M · Calhoun City, MSBuilt 1993 · S/N 1398 N486KWilliams Lawrence J II · Tucson, AZBuilt 2005 · S/N 486 N486MAOrange Wing Aviation Inc · Wilmington, DEBuilt 2006 · S/N 2843636 N486PRichardson Joshua R · Mobile, ALBuilt 1965 · S/N 28-21079 N486PARegistered aircraftBuilt 2023 · S/N 2881621 N486TCMonte D Burke · Dallas, TXBuilt 2004 · S/N 18281446 N486WCoyne Thomas E · Fort Collins, COBuilt 2008 · S/N 91435 N48708Greene Caleb M · Laverne, CAS/N 15280934 N4870DSherman Hess M · Poplar Grove, ILBuilt 1979 · S/N 17272379 N4870GCal Aggie Flying Farmers Inc · Davis, CABuilt 1979 · S/N 17273417 N4870LWinyah Aviation LLC · Georgetown, SCBuilt 1967 · S/N 28-4225 N4870PWooten Gerry W · Edmond, OKBuilt 1980 · S/N 15284834

Back to AD 81-18-04 R2