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.

N4058XLeading Edge Aviation Foundation Inc · Mountain Home, ARFirst renewal noticeBuilt 1970 · S/N 5158 N40592Rml Aircraft Inc · Staunton, VABuilt 1974 · S/N 27-7405337 N4059MTcwh Inc · Hachita, NMBuilt 2022 · S/N 4867 N405AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843738 N405ASJagadeesh Akhil V · Chicago, ILBuilt 1972 · S/N 28-7205263 N405CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881110 N405CMHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 2000 · S/N 3096 N405CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282439 N405DSDelaware State University · Dover, DEBuilt 1976 · S/N 28-7715243 N405DTSkiles Carl A · Leander, TXS/N 17702389 N405EFEagle Flying Club Of Embry Riddle Aeronautical · Daytona Beach, FLBuilt 2012 · S/N 172S11154 N405FAWestosha Flying Club Inc · Kenosha, WIBuilt 2003 · S/N 172S9405 N405FDQualitair LLC Trustee · MichelstadtBuilt 1990 · S/N 770 N405FLRiggin Flight Service Inc · Madison, SDBuilt 1971 · S/N 28-7125181 N405KYSchnabel Jeffrey L · Villa Hills, KYS/N 3132 N405MAHigh Ways LLC · Colorado Springs, COBuilt 2005 · S/N 40.546 N405MHCall One Inc · Clarinda, IABuilt 2024 · S/N 8-10830 N405NDSmith Michael Christopher · Concord, NCBuilt 2004 · S/N 2844113 N405RRBjp Aviation LLC · Seattle, WABuilt 2005 · S/N 10700 N405RVNorberg Robert J · Las Vegas, NVS/N 005 N405SGriffing Flying Service Inc · Port Clinton, OHBuilt 1986 · S/N 2890015 N405SBSky Bright Inc · Gilford, NHBuilt 1978 · S/N 28-7916139 N405SPEastern Cincinnati Aviation Inc · Batavia, OHBuilt 1999 · S/N 172S8298 N405THNewgren Steven A · Kasilof, AKBuilt 1975 · S/N 18-7509005 N405TSRichard N Appling · Ellensburg, WABuilt 1963 · S/N 30-159 N405WFVan Bortel Aircraft Inc · Arlington, TXBuilt 1999 · S/N 18280563 N405XStover Lance E · Eden Prairie, MNBuilt 1976 · S/N 7038C N4060FJones Brent M · Las Vegas, NVS/N 28-7790003 N4060LBentley Aviation Services LLC · Lewes, DEBuilt 1966 · S/N 27-3324 N4060MStall Aero LLC · Burnsville, MNBuilt 1947 · S/N 12-2943 N4060XTroyer Randy · Goshen, INBuilt 1970 · S/N 5160 N40614Marcotte Stuart E · Soldotna, AKBuilt 1972 · S/N 2138C N4061MKrupinski Floyd M · Chugiak, AKBuilt 1947 · S/N 12-2950 N4061NChristensen Kier · Scottsdale, AZBuilt 1968 · S/N 680028 N4061XCorriveaw Florian J · Whitefield, NHBuilt 1970 · S/N 5161 N4061ZJones Michael D · Eagle River, AKBuilt 1963 · S/N 18-8071 N4062EReimler Dan T · Rozet, WYBuilt 1978 · S/N 18-7809047 N4062PLgop LLC · Maple Grove, MNBuilt 1958 · S/N 23-1540 N4063GHorizon Flights Corp · Henderson, NVNon-citizen corporation, flight hours not reportedBuilt 1972 · S/N 34-7250069 N4063XMellon Matthew J · Boone, NCBuilt 1970 · S/N 5163 N4063ZDenton Bobby L · Las Animas, COFirst renewal noticeS/N 18-8073 N4064GLanyi Clifford M · Attleboro, MAS/N 3683 N4064PVali Air Service LLC · Livingston, MTBuilt 1959 · S/N 23-1542 N4064QPasseno Mark A · Cheboygan, MIBuilt 2002 · S/N 296 N4064XMtsh Aviation LLC · Wichita Falls, TXBuilt 1970 · S/N 5164 N4065529 Uniform LLC · Nashville, TNBuilt 1977 · S/N 28-7890005 N4065EKubat Wayne DBA · Wasilla, AKBuilt 1978 · S/N 18-7809052 N4066BKuipers Abram B · Derby, KSBuilt 2007 · S/N 23198 N4066ENelson Flyers Inc · Louise, TXBuilt 1977 · S/N 18-7809057 N40670Cavorite Aviation LLC · Lehi, UTBuilt 1977 · S/N 28-7890007

Back to AD 81-18-04 R2