Registered aircraft · 22,428

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

N131CACoast Flight Training And Management Inc · San Diego, CABuilt 2020 · S/N 2881353 N131LLAims Community College · Greeley, COBuilt 2020 · S/N 2881345 N131LRCharles City Aeronautics Inc · Charles City, IABuilt 1974 · S/N 28-7425258 N131PAAmeriflyers Of Texas Inc · Addison, TXBuilt 2022 · S/N 28020055 N131RJEggleston William A · Wayland, MABuilt 1974 · S/N 28-7415665 N1321HKronick Brad S · Grand Prairie, TXS/N 32R-7780152 N1326TNelson Raul · Annapolis, MDBuilt 1972 · S/N 28-7205286 N1327TCedel Solutions LLC · Austin, TXBuilt 1972 · S/N 32-7240113 N132AMTemple James C · Lincoln, CABuilt 1978 · S/N 28-7990245 N132BCUniversidad Interamericana De Puerto Rico · Bayamon, PRBuilt 2003 · S/N 2843583 N132CACoast Flight Training And Management Inc · San Diego, CABuilt 2020 · S/N 2881354 N132CHSimon Aviation LLC · Bourg, LABuilt 1978 · S/N 32R-7887060 N132DRAasap Construction Co Inc · Conway, SCBuilt 1980 · S/N 32R-8029108 N132GMSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2003 · S/N 3257335 N132GTLegal Eagle 2 LLC · Jefferson City, MOBuilt 2007 · S/N 3257447 N132KMKing General Contractors Inc · Bristol, VAS/N 32-7940161 N132LESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1966 · S/N 32-40038 N132STGrande Aviation LLC · Englewood, FLBuilt 2005 · S/N 3232035 N1330TPremium Air LLC · Bloomfield, MIS/N 28-7225467 N1331LFirst Response Anesthesia Inc · Washington, UTBuilt 1979 · S/N 28-7911074 N1331TValdez Freddy · Fontana, CABuilt 1972 · S/N 28-7225468 N1332TSchwartz Matthew M · Royal Oak, MIBuilt 1972 · S/N 28-7205283 N1333HN1333h LLC · Brooklyn, NYS/N 32R-7780154 N1334TCrt Aviation LLC · Clarkston, MIBuilt 1972 · S/N 28R-7235263 N1335HLmm Solutions LLC · Coppell, TXS/N 28-7725141 N1337TTrate Ava · Selbyville, DEBuilt 1972 · S/N 28-7225394 N133CBBrown Milton S III · Raleigh, NCBuilt 1974 · S/N 28R-7435318 N133DR814ma Inc · Van Alstyne, TXBuilt 2005 · S/N 3255027 N133PTKittle David · Siloam Springs, ARS/N 32-7440136 N133SFNelson Dennis E · Jamestown, NDBuilt 1966 · S/N 28-22323 N1340TMaw Enterprises USA LLC · Hudson, FLBuilt 1972 · S/N 28-7225470 N1341HAlseth Engineering LLC · Kirkwood, MOS/N 28-7790306 N1341TShuman Cecil R Trustee · Chugiak, AKBuilt 1972 · S/N 28R-7235264 N1342HRobertson James P Trustee · Templeton, CABuilt 1977 · S/N 28-7790307 N1342TCrewdawg Aviation LLC · Concord, NCBuilt 1972 · S/N 28R-7235265 N1343TWestern Cherokee Six LLC · Fort Collins, COBuilt 1972 · S/N 32-7240114 N1344HConner W Larry · Los Lunas, NMBuilt 1977 · S/N 28-7790308 N1346TNortham Thaddeus R · Mckinney, TXS/N 28-7205284 N1347HKapp Dean R · New Berlin, WIS/N 28R-7703023 N1347THagan William Jackson · Wetumpka, ALBuilt 1972 · S/N 28-7205285 N1349TMjl Flyers LLC · Somerset, PABuilt 1972 · S/N 28R-7235266 N134CHTeke Elevate LLC · San Antonio, TXBuilt 1978 · S/N 32R-7887138 N134FCDepartment Of Agric & Consumer Svc/S · Tallahassee, FLBuilt 1982 · S/N 28-8290169 N134JSSparling Albert E · Hubbard Lake, MIBuilt 1968 · S/N 28R-30517 N134SFReid Brian S · Merced, CABuilt 1965 · S/N 28-20994 N134VPColclazer John F Jr · Flagstaff, AZBuilt 1965 · S/N 28-21108 N134WSKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2023 · S/N 28020137 N1353YRust Joyce A · Bourbon, INBuilt 1974 · S/N 28-7405152 N1354TRiverside Flight Academy Inc · Riverside, CABuilt 1972 · S/N 28R-7235268 N1355TRmf Trucking LLC · Tuscaloosa, ALBuilt 1972 · S/N 32-7240115

Back to AD 87-08-08 R3