Skip to content

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.

N11KXN11kx LLC · Santa Clara, CABuilt 1981 · S/N 32-8224004 N11LYBishop Jay K · Columbus, INBuilt 1964 · S/N 28-10535 N11NTSabb Anthony · Wetumpka, ALBuilt 1972 · S/N 28-7205193 N11RPN11rp LLC · Brecksville, OHBuilt 1978 · S/N 28R-7803241 N11RRRichardson Randy R · St Thomas, VIS/N 28R-7803076 N11UZEastern Stearman Inc Trustee · Leesburg, VAS/N 3213063 N11YTAnm Air LLC · Grimes, IABuilt 1986 · S/N 32-8606018 N1203TProfessional Locators & Acquisition Specialists Ll · Severance, COBuilt 1972 · S/N 28-7225420 N1204THigh Sky LLC · Ellensburg, WABuilt 1972 · S/N 28-7225421 N1205TAmerican Aircraft Management LLC · Irving, TXBuilt 1972 · S/N 28-7225422 N1206TCps 1 LLC · Pelham, ALBuilt 1972 · S/N 28-7205266 N1207HVenture West LLC · Mesa, AZS/N 28-7790295 N1208HWaldel Ltd · West Lafayette, INS/N 28-7790296 N120CDJackson Farms Callahan Division LLC · Callahan, FLBuilt 1974 · S/N 28R-7435315 N120DGBluesail LLC · Las Vegas, NVBuilt 1981 · S/N 32R-8129077 N120DMWestfall Aviation LLC · Reno, OHBuilt 1973 · S/N 32-7340122 N120MGParagon Airplane Leasing Co · Fort Myers, FLBuilt 2022 · S/N 28020071 N120PWBrookhaven Aviation LLC · Brookhaven, MSS/N 28-7415078 N1213TDyer Gary T · Reno, NVS/N 28-7225423 N1214TPost 8 Flight Opps Inc · Topeka, KSBuilt 1972 · S/N 28-7205268 N1216TOlsen Christopher D · Bothell, WABuilt 1972 · S/N 28R-7235238 N1217TSauer Roger A · Glenburn, NDBuilt 1972 · S/N 28R-7235239 N1218WOndrick Aviation LLC · Chicopee, MABuilt 2003 · S/N 3255006 N121AVPreece William F · Cheshire, CTBuilt 1984 · S/N 28-8490078 N121DBTexins Flying Club · Mckinney, TXBuilt 1972 · S/N 28R-7335024 N121ESWell Bilt Industries USA LLC · Ocala, FLBuilt 1971 · S/N 28-7125383 N121FTBowman William K · Raleigh, NCBuilt 1982 · S/N 28-8216191 N121GHSunset Aviation LLC · Huntington, INBuilt 1977 · S/N 32R-7780262 N121HEJarrett Air LLC · Ashland City, TNBuilt 1979 · S/N 32-7940127 N121JTEffingham Eta LLC · Effingham, ILBuilt 2005 · S/N 3246231 N121LMGolden Age N121lm LLC · Des Moines, IABuilt 2022 · S/N 2881529 N121MDBaggarly Michael · Newnan, GABuilt 1969 · S/N 28-25613 N121SClark William H IV · Thurmont, MDBuilt 1966 · S/N 32-835 N121TCDonney Tom J · Sturgis, SDBuilt 1978 · S/N 32-7840105 N121TFTorres Juan · Modesto, CABuilt 2004 · S/N 3257351 N121TWBlue Ridge Mountain Flyers Aviation LLC · Mineral Bluff, GABuilt 1977 · S/N 32R-7780301 N121WSOrtiz Ramon E · Spring Branch, TXBuilt 1978 · S/N 28R-7803340 N1222TPraniewicz Charles P · New Kensington, PABuilt 1968 · S/N 28R-30582 N1224TAig Aeronautics LLC · Guaynabo, PRBuilt 1999 · S/N 32-57116 N1226TLinde Glenn F Jr · Juneau, WIBuilt 1972 · S/N 28-7205269 N1227TStieper David Paul · Forest Lake, MNBuilt 1972 · S/N 28R-7235241 N1228REcko Air LLC · Springfield, MOBuilt 1989 · S/N 2841266 N122HSMarbury Sherri E · Jackson, TNBuilt 1965 · S/N 28-2377 N122KTRustair Inc · Anchorage, AKS/N 32-7940190 N122MCShouk Aviation LLC · Waverly, OHBuilt 2007 · S/N 2844133 N122NAGilded Gull Aviation LLC · Middletown, RIBuilt 1981 · S/N 28-8216068 N122TEBouchillon James R · Hanahan, SCBuilt 1972 · S/N 32-7340044 N1230UPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020277 N1232TAlexander Charles W · Slidell, LABuilt 1972 · S/N 28-7225430 N12347Butler Construction Services LLC · Oak Grove, MOS/N 32RT-7885055

Back to AD 87-08-08 R3