Registered aircraft · 6,915

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.

N3984TParidee Kevin M Jr · Cumming, GABuilt 1967 · S/N 28R-30335 N3988TPalmetto Standard Aviation LLC · Spartanburg, SCBuilt 1967 · S/N 28R-30340 N3988XMohlenkamp Jami S · Erie, COBuilt 1975 · S/N 28R-7635002 N3991MStaruh Donald E · Pueblo, COBuilt 1978 · S/N 28R-7803211 N3992TDonnelly Charles · Nashua, NHBuilt 1968 · S/N 28R-30347 N3993TAir Alliance Inc · Lexington, KYBuilt 1967 · S/N 28R-30348 N3994TViars Thomas P · Riviera Beach, FLBuilt 1968 · S/N 28R-30349 N3995MParsons John J · Winter Park, FLFirst renewal noticeBuilt 1978 · S/N 34-7870143 N3996FGrim William S · Kingwood, TXBuilt 1976 · S/N 28R-7635394 N3997TBradley Edward T · Jack, ALBuilt 1968 · S/N 28R-30352 N3998FButler Aluminum Of Desoto · Arcadia, FLBuilt 1976 · S/N 32R-7680424 N39CRSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1970 · S/N 39-4 N39CTRotramel Paul D · Hardinsburg, KYBuilt 1968 · S/N 28R-30712 N39EAir Agco LLC · Bell City, MOBuilt 1978 · S/N 34-7870160 N3HMTalley John T · Clifton, TXBuilt 1965 · S/N 24-4277 N3HRDow Glendal R Trustee · Bedford, TXBuilt 1962 · S/N 24-3126 N3MSCarter Zac · Atlanta, GABuilt 1960 · S/N 24-1747 N3NBGaut Jason R · Olathe, KSBuilt 1977 · S/N 32R-7780277 N3SDDanish John S · Hooksett, NHBuilt 1958 · S/N 24-380 N3SGN3sg Enterprises Inc · Wilmington, DEBuilt 1960 · S/N 24-2036 N3TZCasey Edmond L Trustee · Los Angeles, CABuilt 1968 · S/N 28R-30490 N3XEServ Aero Engineering Inc · Salinas, CABuilt 1963 · S/N 30-92 N40001Gaines Harry E · Fontana, CABuilt 1977 · S/N 34-7770356 N40004Tennesen James B · Menomonie, WIBuilt 1977 · S/N 28R-7737126 N40010Sain Ricky F · Vale, NCS/N 28R-7737127 N40024Teton Leasing LLC · Pocatello, IDBuilt 1977 · S/N 28R-7737128 N40033Fly Well Flying Club Inc · Roseville, MNBuilt 1977 · S/N 32R-7780509 N40036Paulay Sandor F · Kenmore, WAS/N 34-7770369 N40046Ponce Annabelle S Brack · Zephyr Cove, NVBuilt 1977 · S/N 28R-7703296 N40065Aldridge Raymond · Moultrie, GABuilt 1977 · S/N 28R-7703302 N40068Van Houten Bradley Thomas · Naples, FLBuilt 1977 · S/N 28R-7737131 N400CBSamper Aviation LLC · Easton, PABuilt 1969 · S/N 28R-31123 N400CJDeepe Mark D · York, NEBuilt 1964 · S/N 26-5 N400EDavis Richard · Reno, NVBuilt 1964 · S/N 26-15 N400FKFinazzo Joseph · Fort Mohave, AZS/N 26-47 N400FW400fw LLC · Largo, FLBuilt 1964 · S/N 26-51 N400GCNorthern Sky Aviation LLC · Harbor Springs, MIBuilt 1965 · S/N 26-80 N400GUTriple S Aviation LLC · Wilmington, DEBuilt 1964 · S/N 26-32 N400HLSale Reported · Lamesa, TXSale reportedBuilt 1964 · S/N 26-86 N400HPMorgan David W · Canton, MIBuilt 1964 · S/N 26-16 N400HRDavis Gary L · Burleson, TXS/N 26-118 N400KKDennehey Patrick N · Cameron Park, CABuilt 1965 · S/N 26-103 N400LBAutumn Crocus LLC · Cincinnati, OHS/N 30-1059 N400NQN400nq LLC · Gleeley, COS/N 26-29 N400PAN6105s LLC · Norwood, NCBuilt 1964 · S/N 26-54 N400PPMig Aviation LLC · Sandy, UTS/N 26-28 N400SWDay Stephen F · Queen Creek, AZS/N 26-112 N400TDHardy Mikel · Twin Falls, IDBuilt 1968 · S/N 30-1708 N400WGRegistered aircraftBuilt 1965 · S/N 26-104 N400WLHammer Construction Corp · Miami, FLBuilt 1965 · S/N 26-148

Back to AD 97-01-01 R1