Registered aircraft · 3,471

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:2002-07-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01') 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:2002-07-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01')
  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:2002-07-01')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01')
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.

N10007Insko Matthew T · Papillion, NEBuilt 1966 · S/N 21058839 N1003AOakshire Aviation LLC · Yakima, WABuilt 1978 · S/N P21000078 N100DBState Of Wisconsin · Madison, WIBuilt 1980 · S/N 21063970 N100GKLewis David B · Saint Louis, MOBuilt 1973 · S/N 210-59905 N100PCSmokey Bay Air Inc · Homer, AKBuilt 1978 · S/N 20700467 N100YNEnrique Angulo · San Diego, CAS/N 21061236 N1011Martin Rex L Trustee · Bakersfield, CABuilt 1980 · S/N 21064004 N101ALRegistered aircraftBuilt 1980 · S/N U20605684 N101EEAlaskan Aerial Photography LLC · Anchorage, AKBuilt 1982 · S/N U20606602 N101JHHi-Per Aviation Inc · Arroyo Grande, CABuilt 1972 · S/N 21059759 N101MTAllman Air LLC · Blackstone, VABuilt 1969 · S/N P20600626 N1020VCraig Air Inc · Wasilla, AKBuilt 1974 · S/N U20602404 N10242Alexander Holding Services Inc · Newark, DEBuilt 1972 · S/N 21059704 N1028RGarner Donald G · Greeley, COBuilt 1980 · S/N P210-00401 N102BNDelta State University · Cleveland, MSBuilt 1978 · S/N U20604268 N102KYPatriot Aviation LLC · Rostraver Township, PABuilt 1978 · S/N P21000093 N1031VIntelinair Geospatial LLC · Indianapolis, INBuilt 1974 · S/N U20602409 N1039GFountain Keith E · Jacksonville, NCBuilt 1979 · S/N 21063174 N103RAArizone Game And Fish Dept · Phoenix, AZS/N U20605995 N10419C Flying K Aviation LLC · Black Hawk, COBuilt 1976 · S/N T21061484 N1046VSusitna Air Service LLC · Anchorage, AKBuilt 1974 · S/N U20602418 N104KJb Aircraft LLC · Anchorage, AKBuilt 1969 · S/N 20700122 N104WDHill Keith D · Kirby, ORBuilt 1979 · S/N P21000366 N1051VSackett Ryan W · Anchorage, AKBuilt 1974 · S/N U20602421 N1061PRemote Properties LLC · Anchorage, AKBuilt 1983 · S/N U20606773 N1065VRegistered aircraftBuilt 1974 · S/N U20602435 N1067MShore Enterprises Of Gainesville LLC · Gainesville, FLBuilt 1970 · S/N 21059367 N1071MJesperson Kenneth R · Ekalaka, MTBuilt 1969 · S/N T210-0451 N107JPPayne Thomas E · Old Forge, NYBuilt 1973 · S/N U20602079 N1083VWoltering Myron B · Granite Bay, CABuilt 1974 · S/N U20602453 N109RCLentfer Clinton H A · Anchorage, AKBuilt 1974 · S/N U20602616 N109RSUnited States Department Of Interior · Boise, IDS/N U20606002 N109SWChugiak Aviation Leasing LLC · Chugiak, AKBuilt 1977 · S/N U20603799 N10DBBrandon Donald A Trustee · El Monte, CABuilt 1977 · S/N 21062016 N10DCHbk LLC · Lynden, WAS/N U206-05366 N10FLRandall P Roumillat · Dallas, TXS/N 21062892 N10HGGerardy Harlan D · Gruver, TXBuilt 1974 · S/N 21060169 N10HLHoyt Robert H Trustee · Canby, ORBuilt 1975 · S/N 21060646 N10HMAggst LLC · Shingle Springs, CABuilt 1978 · S/N 21062908 N10HXIjh Farm Inc · Seminole, TXS/N 21063588 N10RP4f Aviation LLC · Palmer Lake, COBuilt 1972 · S/N 21059779 N10SBSackett Michael · Nordman, IDBuilt 1975 · S/N 21060920 N10TTHays John J Jr · Denton, TXBuilt 1978 · S/N P21000056 N10YSeitz William D · Gordonville, TXBuilt 1972 · S/N 21059697 N10YTN10yt LLC · Missoula, MTBuilt 1976 · S/N 21061460 N110BDArgus Craig J · Atlantic City, NJBuilt 1981 · S/N 21064427 N110HPColt 45 LLC · Tulsa, OKS/N 21059810 N110KMCars Planes And Land LLC · Fuquay Varina, NCBuilt 1983 · S/N 21064800 N110NJState Of New Jersey · Trenton, NJBuilt 1986 · S/N U20606938 N110YDLloyd Clee · Canby, ORBuilt 1975 · S/N 21060858

Back to AD 2002-07-01