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.

N2345RBlue Wave Air LLC · Huntsville, ALBuilt 1981 · S/N 27-8154019 N2345WHanisch Paul J · Crosby, NDBuilt 1998 · S/N E-3188 N2345YJackson Shaun K · Tyler, TXBuilt 1967 · S/N 17700145 N2345ZRegistered aircraftBuilt 1977 · S/N 17270190 N2346FNavion Holdings LLC · Boise, IDBuilt 1964 · S/N 21058546 N2346QBurt Marcus D · Pendleton, ORS/N M-425 N2346TBailey Benjamin J · Lincolnton, GABuilt 1971 · S/N 28-7225050 N2346ZSoutheast Equipment LLC · Sheridan, WYS/N M-65 N2347AGeiselman Eric · Dayton, OHBuilt 1969 · S/N CD-1229 N2347GSmith Steven L · Whitehall, MTBuilt 1998 · S/N TH-1867 N2347QBefumo Joesph M · Manchester, CTS/N M-451 N2347RDillon John C · Flagstaff, AZBuilt 1964 · S/N 18255447 N2347VSomes Jason S · Santa Rosa Valley, CABuilt 1998 · S/N E-3147 N2347XRegistered aircraftS/N 18256247 N2347ZZaitsev Saba A · Brooklyn, NYBuilt 1962 · S/N M-59 N23480Pkp Aviation LLC · Alexandria, VABuilt 1999 · S/N 18280412 N2348GWright Michael Lee · Isanti, MNBuilt 1959 · S/N 51648 N2348JArensmeyer Daniel D · Weybridge, VTBuilt 1963 · S/N M-303 N2348QLegha Jaskirat · Holly Ridge, NCBuilt 1998 · S/N TH-1848 N2348RMiller Robert S · Laurel Springs, NCBuilt 1964 · S/N 18255448 N2348SGeorgia Forestry Commission · Macon, GABuilt 1999 · S/N 18280411 N2348XChessman H Ross · Erie, COBuilt 1965 · S/N 18256248 N2348ZHerrick Herbert D · Flint, MIBuilt 1962 · S/N M-60 N23490Lg Mcdonald Enterprises Inc · Rose Bud, ARBuilt 1992 · S/N 2223 N23497Full Throttle Aviation LLC · Clayton, DEBuilt 2007 · S/N 172S10512 N2349CSchwend Brian · Forsyth, MTBuilt 1953 · S/N 30649 N2349FMilutinovic Christain · Marengo, ILBuilt 1964 · S/N 21058549 N2349GRegistration Pending · Buckley, WARegistration pendingBuilt 1958 · S/N 51649 N2349QLedford Russell R III · Swansea, SCBuilt 1963 · S/N M-417 N2349RSalser Aviation LLC · Ocala, FLBuilt 1998 · S/N 18280413 N2349XNorris James A · Export, PABuilt 1998 · S/N 18280414 N2349ZUnderwood Richard R · Armuchee, GABuilt 1962 · S/N M-61 N234ATr Aero LLC · Poway, CABuilt 1972 · S/N TC-1437 N234ABBachteal Paul Shear · Sebastopol, CABuilt 1991 · S/N CE-1562 N234AJMullins Land Co Inc · Aiken, SCBuilt 1995 · S/N 3246008 N234AMMondkar Avinash M · Payson, AZBuilt 2003 · S/N 051 N234APOrr Lynn E · Fredericksburg, OHBuilt 1988 · S/N CE-1232 N234ARHague Arsh · Orangeburg, NYBuilt 1977 · S/N AA5B0452 N234BAJohnson Alan Lee · Pikeville, KYBuilt 2000 · S/N 869-2000 N234BGLangeland Thomas Arthur · San Antonio, TXBuilt 1965 · S/N 30-909 N234BMHickey John W · Monterey, CABuilt 1985 · S/N 1330 N234BPYoung Tim M Trustee · Edmond, OKBuilt 1992 · S/N 24-3283 N234BWWaring Marvin Barton · Anacortes, WABuilt 1979 · S/N P21000290 N234CSundquist Steven A · Yakima, WABuilt 2006 · S/N 72406 N234CMTallman Donald Depaul · Venice, FLBuilt 1966 · S/N 18257696 N234CPZan Am LLC · Findlay, OHBuilt 2000 · S/N 28-43369 N234DDNunez Christian · Grand Prairie, TXBuilt 1973 · S/N 73-30528 N234DGSnyder Patrick M · Cortland, NYBuilt 2000 · S/N 25039C N234DHCarrell Evan Paul · Queen City, TXBuilt 1969 · S/N D-8966 N234DKKellis Dana S · Farmington, UTBuilt 2024 · S/N 74825

Back to AD 2007-04-19 R1