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.

N4818DBald Eagle Flying Club · South Portland, MEBuilt 1979 · S/N 17272367 N4818FCragg Philip A · Point Roberts, WABuilt 1981 · S/N WA311 N4818LFischer Denise L · Lake View Terrace, CABuilt 1967 · S/N 28-4158 N4818ZCornell Robert C · Lock Haven, PABuilt 1961 · S/N 22-8389 N4819BSunrise Aviation Inc · Ormond Beach, FLBuilt 1979 · S/N 15283654 N4819GVeer Aviation Tx LLC · Houston, TXBuilt 1979 · S/N 17273367 N4819TJacob Rolando V · Las Vegas, NVBuilt 1972 · S/N 28-7205201 N4819ZWest Coast Air Design LLC · Granada Hills, CAS/N 22-8390 N481AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843747 N481ACVogel Lawrence O · Gig Harbor, WAS/N 1289-2000 N481CHHatch Craig R · Lake City, FLBuilt 2007 · S/N 81481 N481CPBlue Water Aviation LLC · Oakman, ALBuilt 2008 · S/N 18282048 N481DMEdgewood Capital LLC · Joplin, MOBuilt 2001 · S/N 1307-2001 N481EMClark Jeffrey V · Libertyville, ILBuilt 1996 · S/N 375-96 N481EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12250 N481GSSchmidt Grant S · Jamestown, NDBuilt 1973 · S/N 28-7325622 N481JLWolfco Timber Services LLC · Lebanon, ORBuilt 2017 · S/N JA1607094 N481MASlavens Timothy W · Howard City, MIBuilt 2003 · S/N 441-2003 N481WSBoer John W · Okeechobee, FLBuilt 2013 · S/N 71940 N481XCMarino Jerry C II · San Francisco, CABuilt 2012 · S/N 111 N48204Young Achilles Hsi-Jung · La Habra, CABuilt 1979 · S/N 15283301 N48205Popinko Charles D · Obrien, FLBuilt 1977 · S/N DEC-2 N4820DBledsoe Duane C · Glendale, AZBuilt 1979 · S/N 17272369 N4820FS&S Aviation Plus LLC · Greenville, ILBuilt 1976 · S/N 28-7790062 N4820GAckerman Garry · Plano, TXBuilt 1979 · S/N 17273368 N4820LFick Paul R · Deansboro, NYBuilt 1967 · S/N 28-4160 N4820SCalico Construction Inc · Kensington, MDBuilt 1979 · S/N R18201432 N4820ZPumford Thomas E Jr · Bannister, MIBuilt 1961 · S/N 22-8391 N4821AMeyer James D · Cheney, KSBuilt 1956 · S/N 22-3974 N4821FOestreich Klaus M · Needville, TXBuilt 1976 · S/N 28-7790063 N4821LFlying Rocks LLC · Sparkill, NYBuilt 1967 · S/N 28-4162 N4821S4821s LLC · Ponte Vedra Beach, FLBuilt 1969 · S/N 32-1252 N48222N1705r Inc · Cobb, CAS/N 15283303 N48228M & L Utility Contractors Inc · Cottondale, FLBuilt 1979 · S/N 15283304 N4822ALybarger Michael L · Hot Springs, ARBuilt 1956 · S/N 22-3975 N4822GHighpoint Strategies LLC · Cypress, TXBuilt 1979 · S/N 17273370 N4822LMonaco Francis Achille · Martinez, GABuilt 1967 · S/N 28-4164 N4822SHolladay Pamela J · Louisville, KYBuilt 1969 · S/N 32-1253 N48238Hamilton Brandon T · Morehead, KYBuilt 1979 · S/N 15283306 N48239Harrell Robert L · Brooksville, FLBuilt 1979 · S/N 15283307 N4823FEden'S Marine LLC · Jensen Beach, FLBuilt 1976 · S/N 28R-7635437 N4823LLaguna Verde Leasing Inc · Wilmington, DES/N 15284233 N4823PWilliams Charles S · Pearland, TXS/N 27-389 N4823TCrane Kenneth J · Clinton, INBuilt 1972 · S/N 32-7200025 N4823VStratus Air LLC · New Orleans, LAFirst renewal noticeBuilt 1980 · S/N 172RG0391 N48241Evans Christopher Warren · Demotte, INBuilt 1979 · S/N 15283308 N48244Kelly Kevin J · Lancaster, NYBuilt 1979 · S/N 15283310 N4824GHickman Robert B · La Follette, TNBuilt 1979 · S/N 17273372 N4824PMikhailau Ivan · Alpine, UTBuilt 1980 · S/N 15284823 N4824SWilly Jack LLC · Wickenburg, AZBuilt 1970 · S/N 32-1255

Back to AD 81-18-04 R2