Registered aircraft · 108,433

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:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') 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:2007-04-19-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
  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:2007-04-19-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
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.

N2551TIllinois Aviation Inc · Englewood, FLBuilt 1970 · S/N NAV-4-2551 N2551UPizzuto Samuel J · Chamblee, GABuilt 1979 · S/N 28-8016034 N2551XMcgrath Paul · Potsdam, NYBuilt 1965 · S/N P206-0051 N2551ZHobson Simon · Eagle River, AKBuilt 1977 · S/N 999-77 N2552KRicci Harry A · Kokhanok, AKBuilt 1978 · S/N 18052983 N2552RHooper Jerald Ray · Parker, AZBuilt 1967 · S/N 18258252 N2552WNahas Rafik E · Laguna Niguel, CABuilt 1965 · S/N 920 N2552XN2552x LLC · Boulder, COBuilt 1964 · S/N P206-0052 N2553GRegistered aircraftS/N 51853 N2553MRubbert Jan D · Upham, NDBuilt 1946 · S/N 12-1012 N2553QSanders William R Jr · Lafayette, COBuilt 1966 · S/N 18257753 N2553RDepore Joseph E · Charleston, SCBuilt 1967 · S/N 18258253 N2553TDavis David F · Oregon, ILBuilt 1974 · S/N 2553 N2553WBrown Jeffrey B · Punta Gorda, FLBuilt 1965 · S/N 3265 N2553YMacair Aviation LLC · Xenia, OHBuilt 1985 · S/N 28-8516079 N2554KBelleair Aviation LLC · Clearwater, FLS/N 18052985 N2554RBartlett Richard H · Sussex, NJBuilt 1967 · S/N 18258254 N2554TAlvion LLC · Unionville, INBuilt 1975 · S/N NAV-4-2554 N2554WThomas Ryan · Carolina Beach, NCBuilt 1966 · S/N 1014 N2554XWallin Justin · Henderson, NVBuilt 1964 · S/N P206-0054 N2554ZClement L Ross · Anchorage, AKBuilt 1963 · S/N 185-0554 N25552Region Flyers LLC · Valparaiso, INBuilt 1985 · S/N 28-8516081 N2555BHadden Fleming Cindy L · San Antonio, TXS/N 28-25678 N2555PJohnson Alwyn J · Karlstad, MNBuilt 1955 · S/N 22-2889 N2555TFrez Raymond · Jacksonville, FLBuilt 1975 · S/N NAV-4-2555 N2556MTennyson Chad E · Ridgefield, WABuilt 1946 · S/N 12-1040 N2556XHusnik Brad M · Forest Lake, MNFirst renewal noticeBuilt 1964 · S/N P206-0056 N2557PMcmahon Thomas F · Yakima, WABuilt 1955 · S/N 22-2920 N2557RWhite Willis W · Boise, IDBuilt 1967 · S/N 18258257 N2557TSouthwest Aircraft LLC · Fairacres, NMS/N NAV-4-2557 N2557WAndre Norman C · Downers Grove, ILBuilt 1965 · S/N 923 N2557XRegistration Pending · Troy, IDRegistration pendingBuilt 1964 · S/N P206-0057 N2558GScolari Shawn Fenton · Meeteetse, WYS/N 51858 N2558LHoecher Robert · Anchorage, AKS/N 17255758 N2558RKahn Steven P · Boise, IDBuilt 1967 · S/N 18258258 N2559JStuder Alfred C · Shelby, MIBuilt 1979 · S/N T18803482T N2559PSale Reported · Oklahoma City, OKSale reportedBuilt 1955 · S/N 22-2922 N2559QJordan Valley Aviation LLC · Jordan Valley, ORBuilt 1966 · S/N 18257759 N2559STrue Altitude LLC · Isola, MSBuilt 1979 · S/N 18-7909160 N2559WHighfill Randall W · Hannibal, MOBuilt 1965 · S/N 3268 N2559XElement Building Solutions Inc · Murphys, CABuilt 1965 · S/N P2060059 N255AOld Aircraft Inc · Lake City, FLBuilt 1956 · S/N 35285 N255ATThompson Aaron R · Louisville, KYS/N 18280060 N255BABgp Realty Inc · Boca Raton, FLBuilt 1967 · S/N TE-364 N255BSScheeler Gerard M · Granbury, TXBuilt 2001 · S/N 0069 N255CBZions Credit Corp · Salt Lake City, UTBuilt 2020 · S/N 2881390 N255CETextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2024 · S/N 18283255 N255CPSierra Papa Delta LLC · Murphysboro, ILBuilt 2014 · S/N 40485 N255DHudec Darryl L · Stone Mountain, GABuilt 2022 · S/N 184 N255DHMarina Electric Inc · Cutler Bay, FLBuilt 1994 · S/N 3213079

Back to AD 2007-04-19 R1