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.

N2323ECherokee Beech Boys LLC · Kennesaw, GABuilt 1998 · S/N E3187 N2323FMattern Rodney · Napoleon, NDS/N 21058523 N2323GLeone Daniel M · Pueblo, COBuilt 1958 · S/N 51623 N2323MPacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-7954039 N2323PMertens Michael R · Denton, NEBuilt 1955 · S/N 22-2734 N2323TTweeddale Thomas A · Denton, TXBuilt 1971 · S/N 28-7125606 N2323VHella Copters LLC · Columbus, OHBuilt 2002 · S/N 10005 N2323ZCalahan Spencer H · Baton Rouge, LABuilt 2023 · S/N 18283245 N2324AFst Aviation & Logistics LLC · Sheridan, WYBuilt 1997 · S/N E-3124 N2324FLong Rendell L · Woodbridge, VABuilt 1964 · S/N 21058524 N2324L2324l LLC · Sharpsburg, GABuilt 1963 · S/N M-150 N2324MLeonard Stephen P · Anchorage, AKBuilt 1946 · S/N 12-1488 N2324RKincheloe Ralph H · Jerome, IDBuilt 1964 · S/N 18255424 N2324WTolhurst Bruce Clinton · Silver City, NMBuilt 1965 · S/N MA-1 N2324XSchutjet Dennis · Clear Lake, IABuilt 1965 · S/N 18256224 N23251Smith Lyndsey P Trustee · Anchorage, AKBuilt 1976 · S/N 18503078 N2325FStephen N Ruark Farm Services Inc · Pantego, NCBuilt 1964 · S/N 21058525 N2325PCarnahan Thomas L · Wasilla, AKS/N 22-2736 N2325RLucky Catch LLC · Canton, MSS/N 18255425 N2325TFlorida State College At Jacksonville · Jacksonville, FLBuilt 1971 · S/N 28R-7135201 N2326AValcourt Robert F · Chicopee, MABuilt 1998 · S/N E-3165 N2326BRandigo LLC · Wilmington, DEBuilt 1978 · S/N U20604470 N2326RSinger Don · Oxnard, CABuilt 1964 · S/N 18255426 N2326URodger Roberts Inc · Winchester, OHBuilt 1979 · S/N 28-7911296 N2326VEby Thomas R · Winter Springs, FLBuilt 1985 · S/N 28-8590067 N2326WSahli Theodore · Costa Mesa, CAS/N 2109 N2326XFerris Elden L · Vancouver, WABuilt 1965 · S/N 18256226 N2327AN2327a LLC · Murrells Inlet, SCBuilt 1997 · S/N E-3127 N2327COlson Helicopters LLC · Corpus Christi, TXBuilt 1991 · S/N 2020 N2327FWilliams Stephen Mark · Fort Walton Beach, FLBuilt 1964 · S/N 21058527 N2327PRoa Rembrandt Aguspina · Anchorage, AKBuilt 1955 · S/N 22-2738 N2327TSale Reported · Hampton, GASale reportedBuilt 1971 · S/N 28R-7135216 N23281Sosa Jonathan · Orlando, FLBuilt 1974 · S/N 17264082 N2328RYoung Airmans Association Inc · Arverne, NYBuilt 2005 · S/N 172S9989 N2328TElite Flight LLC · Lordstown, OHBuilt 1971 · S/N 28R-7135217 N2328YRogue Air LLC · Miller, SDBuilt 1967 · S/N 17700128 N2328ZEagle Richard R · Catawba, NCBuilt 1962 · S/N M-31 N23291Oracle Aviation LLC · Omaha, NEBuilt 1974 · S/N 17264083 N2329EMeshoppen Air LLC · Meshoppen, PABuilt 1978 · S/N 17271235 N2329GRegistration Pending · Eagle River, AKRegistration pendingBuilt 1959 · S/N 51629 N2329LJessup Gordon J R · White Plains, NYBuilt 1963 · S/N M-160 N2329PPapst David · Freeland, MIBuilt 2024 · S/N 72-137/138 N2329RRivers Andrew · Midland Park, NJS/N 18255429 N2329TColvin Timmy R · Valentine, NEBuilt 1971 · S/N 28-7110028 N2329WSwonke Adam J · Spring, TXBuilt 1966 · S/N MB-20 N2329YHeppe Andrew S DBA · Turner, MTBuilt 1981 · S/N 36-8160002 N232AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281180 N232ASGuggenair LLC · Carbondale, COBuilt 1978 · S/N 310R1369 N232CDavid Stix Jr · Fernley, NVBuilt 1998 · S/N 1442 N232CDNew Paul · Jackson, TNBuilt 2002 · S/N 0187

Back to AD 2007-04-19 R1