Registered aircraft · 68,377

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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.

N3970XStrand Stephen E · Pelican Rapids, MNBuilt 1975 · S/N 28-7515437 N39711Martin Mike · Carnesville, GABuilt 1978 · S/N 28-7990009 N39715Pierce Martin J · Muncie, INBuilt 1978 · S/N 28-7990010 N3971KRegistered aircraftBuilt 1968 · S/N 28-23856 N3971MAllen Richard P · Southampton, NJBuilt 1947 · S/N 12-2599 N3971NBravo Aviation LLC · Rexburg, IDBuilt 1968 · S/N 680010 N3971PIsaak James A · Soldotna, AKBuilt 1956 · S/N 18-4762 N3972KPeak William G Jr · Westview, KYBuilt 1967 · S/N 28-23857 N3972MIntricate Bay Operating LLC · Saylorsburg, PAS/N 12-2900 N3972PSc Super Cub LLC · Rosharon, TXBuilt 1956 · S/N 18-4763 N3972QStiles Thomas · Mechanicsville, VABuilt 1971 · S/N 17260072 N3972TQualitair LLC Trustee · MichelstadtBuilt 1967 · S/N 28R-30321 N3972XSoares Jeffrey A · Aptos, CABuilt 1975 · S/N 28R-7535378 N39731F5 Industries LLC · Tacoma, WAS/N 28-7916002 N39732Love Richard F · Egg Hbr Twp, NJBuilt 1978 · S/N 28-7990013 N39739Vy Partners LLC · Louisville, KYBuilt 1978 · S/N 28-7990015 N3973QIdg Elsa LLC · Ann Arbor, MIBuilt 1971 · S/N 17260073 N3973TMeissner Edward T · Hartland, WIBuilt 1967 · S/N 28R-30322 N39747Cardano Aviation LLC · Newton, NCBuilt 1978 · S/N 28-7990016 N39749Lentz Kenneth C · Gaylord, MIBuilt 1978 · S/N 28-7990017 N3974MValia Sachin N · Landis, NCBuilt 1978 · S/N 28-7816394 N3974RAuclair Bill T DBA · Winsted, CTBuilt 1971 · S/N 28-7105080 N3975KGlissman Robert D · Mystic, CTBuilt 1967 · S/N 28-23861 N3975QBrachtenbach Eric L · Hill City, KSS/N 17260075 N3975ZKnefley Michael J · Ulysses, PAS/N 18-7914 N3976Shepp Kenneth J · Garberville, CABuilt 1976 · S/N 1 N3977GSinor Delbert · Ozark, MOBuilt 2011 · S/N 23877 N3977NKelley Daniel P · Newton, ALBuilt 1968 · S/N 680151 N3977PPetrides Christopher James · Honolulu, HIBuilt 1956 · S/N 18-4768 N3977QLabanoski Mark B · Hornell, NYS/N 17260077 N3977RSusens Dennis W · Columbia Falls, MTBuilt 1971 · S/N 28-7105082 N3977TBeauman James · Indianapolis, INBuilt 1967 · S/N 28R-30327 N39787Karman William Neal · Lake Stevens, WABuilt 1973 · S/N 551 N39789Ahlhorn Travis · San Marcos, TXS/N 553 N3978MSchrier Timothy M · Savage, MNBuilt 1947 · S/N 12-2901 N3978PNicklas William T · Rllng Hls Est, CABuilt 1977 · S/N 15279647 N3978QDv Aircraft Leasing · Green Bay, WIBuilt 1971 · S/N 17260078 N39791Mcmullen Albert J · Corsicana, TXBuilt 1973 · S/N 555 N3979KGrams Terry · Smithville, MOBuilt 1967 · S/N 28-23866 N3979QCarey International Aviation Services LLC · Rockville Centre, NYBuilt 1971 · S/N 17260079 N3979RClinton Flying Service Inc · Clinton, NCBuilt 1971 · S/N 28-7105084 N3979ZHamilton Stephen L · Eagle River, AKBuilt 1963 · S/N 18-7916 N397ABFlybravo LLC · Jasper, TXBuilt 1997 · S/N 1 N397DPParkman David A Jr · Lead Hill, ARBuilt 2021 · S/N 74880 N397JHHegy Thomas R · Rubicon, WIBuilt 2000 · S/N 1319 N397LJJohnson Jeffrey L · Fargo, NDBuilt 1975 · S/N 18-7609018 N397MAHalron James M · Green Bay, WIS/N 2155 N397MLLittleton Bradley · Weatherford, TXBuilt 2023 · S/N 74105 N397PAStelzle Scott A · Templeton, CABuilt 1940 · S/N 5-397 N397RCRegistered aircraftBuilt 1978 · S/N MC-631

Back to AD 90-04-06 R1