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.

N20957Mustang Sally Aviation LLC · Camden, SCBuilt 2004 · S/N 172S9571 N20958Ras Aviation LLC · Elyria, OHBuilt 1978 · S/N 28-7916020 N2095GRegistration Pending · Bozeman, MTRegistration pendingS/N 51395 N2095KCalifornia In Nice Inc · San Jose, CAS/N 44-7995180 N2095PForbes Richard L · Plano, TXBuilt 1956 · S/N 23-683 N2095RTyson John H · Melba, IDS/N 18255295 N2095WOnnoh Fred · Oak Harbor, WABuilt 1979 · S/N 28R-7918077 N2095XMiller Michael D · Goffstown, NHBuilt 1965 · S/N 18256195 N20962Fairmont Field LLC · Enid, OKBuilt 1972 · S/N 18261324 N20965Reich Aviation LLC · Loudon, TNBuilt 1974 · S/N 17263883 N20966Gibson Todd W · Madisonville, LABuilt 1972 · S/N 18261327 N20969Kembel Robert D · Saint Ignatius, MTBuilt 1976 · S/N 18503049 N2096BN2096b LLC · Buffalo, NYBuilt 1978 · S/N 28-7911008 N2096LMcfarland Bruce R · Newberry, FLBuilt 1978 · S/N 28-7916242 N2096RBeasley Tim · Summerland Key, FLBuilt 1964 · S/N 18255296 N2096TDufur Casey L · Durant, OKBuilt 1971 · S/N 28R-7135041 N20970Hitt James Randy · Blue Springs, MSBuilt 1972 · S/N 18261330 N20972Esmiol Matthew · Marlborough, CTBuilt 1972 · S/N 18261331 N20975American Union Printing Inc · Chino Valley, AZBuilt 1972 · S/N 18261333 N20976Kwolik Jordan M · Mckinney, TXBuilt 1972 · S/N 18261334 N20978Crosswinds Flying Club Inc · Oakland, MIBuilt 1972 · S/N 18261336 N2097GMountain Air Aviation LLC · Fruit Heights, UTBuilt 2004 · S/N 172S9662 N2097NSidney Flying Club Inc · Sidney, OHBuilt 1979 · S/N 28-7916257 N2097RWilson Wayne D · Saratoga Springs, NYBuilt 1964 · S/N 18255297 N2097SLong Island Aviators LLC · Seaford, NYBuilt 2004 · S/N 18281308 N2097TPatriot Aviation Inc · Greenville, DEBuilt 2004 · S/N 172S9585 N2097UNorris Barry D · Soquel, CABuilt 1979 · S/N 28-7916311 N2097XSouth Carolina Forestry Commission · Columbia, SCBuilt 1965 · S/N 18256197 N20980White Duane A · Wappingers Falls, NYBuilt 1972 · S/N 18261337 N20986Skylane Flying Club Inc · Omaha, NEBuilt 1972 · S/N 18261342 N2098PRegistration Pending · Granger, IARegistration pendingS/N 23-686 N2098TIsaacs Brandon · Homedale, IDBuilt 1971 · S/N 28R-7135043 N2098WHolland Greg R · Irvine, CABuilt 1966 · S/N CE-9 N2098XKuefler Michael J · Saint Ignatius, MTBuilt 1965 · S/N 18256198 N2099Paragon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020179 N20992Sketo Aviation LLC · Bardstown, KYBuilt 1978 · S/N 28-7990030 N2099CFrazier Jon A · Vista, CAS/N TD-276 N2099DRollins Dale G · Covington, LABuilt 2004 · S/N 17281204 N2099GHilten Robert W · Columbus, MTBuilt 1958 · S/N 51399 N2099NMicheal Charles E · Arlington, TXBuilt 2004 · S/N 18281333 N2099TArrowmark LLC · Schroeder, MNBuilt 1971 · S/N 28R-7135044 N2099WInternational Air Services Inc Trustee · Carson City, NVBuilt 2000 · S/N 80438 N2099XGreen Glen A · Willits, CABuilt 1965 · S/N 18256199 N209AGSkyfarm Leasing LLC · Dos Palos, CABuilt 2023 · S/N 14624 N209ARGeery James J · North Fort Myers, FLBuilt 2007 · S/N 71261 N209ASCherokee Bill Aerovation LLC · Gainesville, GABuilt 2005 · S/N 40.554 N209BZHipple Patrick · Brecksville, OHS/N SS890830 N209CCCampbell Aviation Inc · Dutton, MTBuilt 1997 · S/N 20209 N209DBCreedon William P · Escondido, CABuilt 1971 · S/N 139 N209DCDelaware Corp · Topping, VABuilt 1979 · S/N 414A0229

Back to AD 2007-04-19 R1