Registered aircraft · 81,728

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.

N278ACLetourneau University · Longview, TXBuilt 2001 · S/N 1385-2001 N278AGEpic Aviation Inc · New Smyrna Beach, FLBuilt 2020 · S/N 4496506 N278CA278ca LLC · Union Gap, WABuilt 2008 · S/N 172S10801 N278CCUS Department Of The Interior · Boise, IDBuilt 2012 · S/N CC18-0057 N278CMVarakantham Indra Sena Reddy · Allen, TXBuilt 2004 · S/N 40.391 N278DSRelm Air LLC · Wilmington, DEBuilt 2003 · S/N 40.278 N278FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13453 N278FKKoelbl Aviation LLC · Whitesboro, TXBuilt 2003 · S/N 3417 N278HBEastman Douglas F · Eastlake, COBuilt 1982 · S/N 278 N278JGThompson Barrett R · Smyrna, TNBuilt 1998 · S/N JS-001 N278KERotor Technologies Inc · Nashua, NHBuilt 2006 · S/N 11178 N278MGGeorgia Aviation Authority · Eastman, GABuilt 2018 · S/N 2881019 N278MHSimms Hospitality Group LLC · El Segundo, CABuilt 2022 · S/N 3400 N278NDRegistered aircraftBuilt 2002 · S/N 2844069 N278RVBridges Carl R · Port Saint Lucie, FLBuilt 2012 · S/N 71606 N278SAInternational Air Services Inc Trustee · Carson City, NVBuilt 1974 · S/N 177RG0571 N278SHSmith Kenneth S Jr · Uvalde, TXBuilt 2007 · S/N 4224 N278SPSvetful Aviation LLC · Camden, SCBuilt 2003 · S/N 172S9474 N278ZKennerson Robert L · Palmer, AKBuilt 1981 · S/N 18-8109030 N2790WMoondogger LLC · Yakima, WAS/N 1068 N27918Reneau Thomas E · Midland, TXBuilt 2001 · S/N 2974 N2791PMccarthy Air LLC · Palmer, AKBuilt 1955 · S/N 18-4426 N2791WToothman John · Fairmont, WVS/N 1069 N2792PVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1955 · S/N 18-4427 N2793WSchneider Aerial Inc · Rugby, NDBuilt 1966 · S/N 3365 N2793Y3y Leasing LLC · Englewood, COBuilt 1958 · S/N TD-166 N2794Autry Timothy R · Stedman, NCBuilt 1971 · S/N 80A N2794MRifenburg Brian K · Ward Cove, AKS/N 12-1252 N2795JEndeavour Flight Training Inc · Miami, FLBuilt 1979 · S/N 17273650 N2796WPennington Jeffrey B · Wrightwood, CABuilt 1966 · S/N 1072 N2797EPalm Beach Flyers LLC · Boca Raton, FLS/N 17271324 N2797WWebb John H Jr · Paulding, OHBuilt 1966 · S/N 1073 N2798CStone Aviation LLC · Sacramento, CABuilt 1978 · S/N R18200228 N2798EPumpkin Eater LLC · Tavares, FLBuilt 1978 · S/N 17271325 N2798WSb Enterprise LLC · Marshall, TXBuilt 1966 · S/N 3367 N279AGWings Over Texas Holdings LLC · Denton, TXBuilt 2020 · S/N 4496507 N279BWLee Douglas Anthony · Quincy, CAS/N 279 N279CGDelaware State University · Dover, DEBuilt 2000 · S/N 2843399 N279KMarble Rick W · Hartford, IABuilt 2014 · S/N 90859 N279LAFive Star Marketing Inc · Morrisville, NCBuilt 2026 · S/N 377/US N279LGAltius Aviation LLC · Syracuse, NYBuilt 1986 · S/N 28-8611004 N279MASd Aviation LLC · Danville, CABuilt 2007 · S/N 1040-2007 N279MGGeorgia Aviation Authority · Eastman, GABuilt 2018 · S/N 2881020 N279NDSowela Technical Community College · Lake Charles, LABuilt 2000 · S/N 2844034 N279PWMauck Ryan S Trustee · Bend, ORBuilt 1985 · S/N 28-8590059 N279RARusso Robert Michael · Pipersville, PABuilt 2005 · S/N 1392-2005 N279RMBingham Sammy J · Manvel, TXBuilt 1992 · S/N 513 N279RVStewart James L · Garden City, TXBuilt 2016 · S/N 90299 N279TAspenglow LLC · Talkeetna, AKS/N 18-2393 N279WMMcmartin Cutler J · Roanoke, TXBuilt 2021 · S/N 83392

Back to AD 81-18-04 R2