Registered aircraft · 6,916

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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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.

N2227WAb Christenson Holdings LLC · Bluffdale, UTBuilt 1979 · S/N 34-7970171 N2228UPeak Leasing LLC · Anchorage, AKBuilt 1979 · S/N 34-7970156 N222HLDouble K Flying LLC · Scottsboro, ALBuilt 1961 · S/N 24-2670 N222PTFme Aviation LLC · Wheelersburg, OHBuilt 1978 · S/N 28R-7803342 N222RACaptain Rick LLC · Miami Lakes, FLBuilt 1973 · S/N 28R-7435127 N222RSDawson Douglas L · Fernley, NVBuilt 1978 · S/N 28R-7803221 N2235WSamuels Walter E · Wilmington, NCBuilt 1969 · S/N 30-1844 N2236MC6 Aviation LLC · Hoboken, NJBuilt 1977 · S/N 32R-7880054 N2239D41 Investments Gp LLC · Sinton, TXBuilt 1978 · S/N 34-7970011 N223JDFlynt Kevin D · Decorah, IAS/N 28R-7803042 N223WWSan Diego Flight Training Inc · San Diego, CABuilt 1978 · S/N 28R-7837251 N223XSaleem Sandhu M · Santa Clara, CAS/N 34-7970288 N2240DOhnback Ulf · Spokane, WABuilt 1978 · S/N 34-7970032 N2244BIntegrated Milk LLC · Dimmitt, TXBuilt 1978 · S/N 34-7970009 N2247MCamp Randall · Duncan, SCBuilt 1977 · S/N 28R-7837073 N2247WButts Alan R · Bismarck, NDS/N 28R-7703159 N224HSHenderson State University · Arkadelphia, ARBuilt 2007 · S/N 2844131 N224KJam Three LLC · St George, UTBuilt 1959 · S/N 24-1609 N2253MOgata Randy Lynn · Yuma, AZBuilt 1977 · S/N 28R-7803116 N2255YShogren Scott F · Fort Pierce, FLS/N 30-1268 N225PACapitol Aircraft Inc · Wilmington, DEBuilt 1976 · S/N 28R-7635443 N225PKInternational Air Services Inc Trustee · Carson City, NVS/N 32R-7780086 N2263QRoss Air Chicago LLC · Chicago, ILBuilt 1977 · S/N 28R-7737030 N2266MGraves Robert E · Danville, INBuilt 1977 · S/N 28R-7837075 N2266QJudkins James C · Alpharetta, GABuilt 1977 · S/N 32R-7780237 N2268YMohr Marcia L DBA · New Richmond, WIBuilt 1964 · S/N 30-544 N2269MSpencer Donald I Jr · Knoxville, TNBuilt 1977 · S/N 32R-7880060 N226BVKimberlin G Tyler · Fairbury, NEBuilt 1976 · S/N 32R-7680225 N226MAdams Larry Gene · Parker, AZBuilt 1960 · S/N 24-2326 N2272TNedley Nathan D · Georgetown, KYBuilt 1972 · S/N 28R-7235001 N2273TDevenezia Robert P · Brentwood, TNBuilt 1971 · S/N 28R-7135175 N2274THoller James F · Stuart, FLBuilt 1971 · S/N 28R-7135176 N2276MMuddy River Capital LLC · Glendive, MTBuilt 1977 · S/N 28R-7803119 N2277QComanche Aviation LLC · Chanute, KSBuilt 1977 · S/N 28R-7703060 N2279TRegistration Pending · Lakeville, MNRegistration pendingBuilt 1971 · S/N 28R-7135181 N227ALGarbar Organization LLC · Duncan, SCBuilt 1975 · S/N 34-7670028 N2284MGulf Coast Air LLC · Lakeland, FLBuilt 1977 · S/N 34-7870077 N2285MBowman Field Aviation Club Inc · Louisville, KYBuilt 1977 · S/N 34-7870078 N2285QGandy John W III · Mount Vernon, TXBuilt 1977 · S/N 28R-7737032 N2286QRinker John W · Pontiac, ILBuilt 1977 · S/N 28R-7703062 N2288QMidnight 30 LLC · Columbia, MSBuilt 1977 · S/N 32R-7780242 N228FPRegistered aircraftS/N 24-2538 N228NCIal Corp · Lewes, DEBuilt 1969 · S/N 28R-35652 N228TXTexas State Technical College · Waco, TXBuilt 2007 · S/N 2844136 N2292MShymkewich Dale G · Arlington, VABuilt 1977 · S/N 28R-7837081 N2293MFines Aviation #1 LLC · Fargo, NDBuilt 1977 · S/N 28R-7837082 N2294QSouth Florida Helicopters Inc · Indiantown, FLS/N 28R-7737033 N2296QKhawly Pablo Nickolai · Miramar, FLBuilt 1977 · S/N 32R-7780244 N2297MHunter Stokes & Associates LLC · Douglasville, GABuilt 1977 · S/N 32R-7880061 N2297QFact Ware Inc · Newtown, PABuilt 1977 · S/N 32R-7780245

Back to AD 97-01-01 R1