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.

N255EM255em LLC · Tampa, FLBuilt 1973 · S/N TC-1552 N255EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2025 · S/N 172S13316 N255FFry Peter J · Monument, COBuilt 2004 · S/N 3 N255FLCoutts Dylan A · Windsor, MEBuilt 1998 · S/N 18280241 N255FSSharpline Converting Inc · Wichita, KSBuilt 1980 · S/N TC-2306 N255JSFalcon Helicopters Inc · Logan, NMS/N 364 N255KBailey Michael S · Sarasota, FLBuilt 1961 · S/N TC-74 N255LCTrayer Jared T · Rollinsford, NHBuilt 2019 · S/N 2587 N255LLChandler Elijah J S · Pilot Mountain, NCS/N 082 N255MAKmco Inc · Lenexa, KSBuilt 1967 · S/N TE-318 N255MBPhoenix Aircraft Management LLC · Marathon, FLFirst renewal noticeBuilt 1968 · S/N 310N-0110 N255MEFalbo Michael Wayne · Sellersburg, INBuilt 2000 · S/N 18280765 N255PCWinger Michael J · Boulder Junction, WIBuilt 2002 · S/N 5173 N255PKTexas Specialty Hunts Inc · San Angelo, TXBuilt 2025 · S/N 14925 N255PSSamani David L · Lincoln, NEFirst renewal noticeBuilt 1996 · S/N 5336 N255RWas Group LLC · Wilmington, DEBuilt 1973 · S/N TC-1518 N255SCSouth Georgia Technical College · Americus, GABuilt 2005 · S/N 3772 N255SFKcsi Aerial Patrol Inc · Bakersfield, CABuilt 2000 · S/N 1287-2000 N255SKParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020130 N255TJackson Travels LLC · Quitman, TXBuilt 2024 · S/N 1216-2024 N255TJVolar II LLC · Edmond, OKBuilt 2016 · S/N 4496394 N255VSVertical Solutions LLC · Valdez, AKFirst renewal noticeBuilt 2014 · S/N 13685 N255WAChapman Chad E · Blakely, GABuilt 2010 · S/N 40847 N255WFKlapmeier Alan L · Iron River, WIBuilt 1981 · S/N R18201655 N255WPUnited States Air Force Owner · Hanscom Afb, MAFirst renewal noticeS/N TF-38 N255XKnop Courtney Dee · Vernal, UTS/N 20450 N255XMS-Tee Corp · Mineri Wells, TXBuilt 1966 · S/N TE-263 N255ZSmall Terry A · Vernal, UTBuilt 2019 · S/N 048-171/172-544 N2560GJackson Air LLC · Temecula, CABuilt 1959 · S/N 51860 N2560PBader Regan R · Saint Libory, NEBuilt 1955 · S/N 22-2923 N2560XCd Hillcroft Aviation LLC · Superior, COBuilt 1965 · S/N P206-0060 N25612Mad Scientist Aviation LLC · Wilmington, DES/N TE-897 N25615Roark Co Inc · Montgomery, ALBuilt 1973 · S/N E-460 N2561QMariposa Aviation Inc · East Wenatchee, WABuilt 1966 · S/N 18257761 N2561RHeber Valley Flying Club · Park City, UTBuilt 1967 · S/N 18258261 N2561TBlumenstock Kenneth A · Culpeper, VABuilt 1976 · S/N NAV-4-2561 N2561WStaker Bryan P · Pleasanton, CAS/N 925 N2561XN343ga Leasing LLC · Anchorage, AKBuilt 1965 · S/N P206-0061 N2561ZMcbride Steve · Shamong, NJBuilt 1977 · S/N 353-77 N25625Martinez Maurice Dominic · La Habra, CABuilt 1973 · S/N E-393 N25627Sutter Jacob O · Roland, ARBuilt 1973 · S/N TH-295 N2562FMans David A · Gruver, TXBuilt 1965 · S/N 35 N2562KPodany John R · Aledo, TXBuilt 1988 · S/N 922 N2562MPacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-7954078 N2562QStiles Thomas W · Pocahontas, ILBuilt 1966 · S/N 18257762 N2562RKehler Grain & Livestock · Saint Xavier, MTBuilt 1967 · S/N 18258262 N2562UJust Plane People LLC · Irvine, CABuilt 1979 · S/N 28-8090056 N25632Struck Larry G · Gardnerville, NVS/N D-9435 N25633Paolercio Alan D · Grants Pass, ORBuilt 1973 · S/N D-9438 N2563SClements Kenneth Brian · Las Vegas, NVBuilt 1976 · S/N 21061330

Back to AD 2007-04-19 R1