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.

N1484TPolasik Julia Suzanne · Victor, IDBuilt 1972 · S/N 28-7225531 N1484XAlpha-One Air Service LLC · Concord, NCBuilt 1975 · S/N 28-7505233 N1485XBond Bryce W · Chandler, AZBuilt 1975 · S/N 28R-7535290 N1486HLynn John · Coffee Creek, MTS/N 28-7716026 N1486TSpivey Darwyn D · Guntersville, ALBuilt 1972 · S/N 28-7225533 N1486XMidwest Investment Corp · Griffith, INS/N 28R-7535291 N1487TFalcon Flying Club LLC · Fayetteville, GABuilt 1972 · S/N 28-7205307 N1488HDeplazes Anthony · Rugby, NDS/N 28-7716027 N1489TLion Aviation LLC · Kansas City, MOBuilt 1972 · S/N 32-7200042 N148AParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020203 N148FCDepartment Of Agriculture & Consumer Scvs · Tallahassee, FLBuilt 2022 · S/N 2881520 N148KMRstl LLC · Minster, OHS/N 28-7990342 N148LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842191 N148RFPaklook Air Inc · Bethel, AKBuilt 1976 · S/N 32R-7680076 N1490HKoepke Jeffrey J · Waterford, WIS/N 28-7790316 N1490WTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1976 · S/N 28-7690282 N1490XTwin Peaks Holdings · Midvale, UTBuilt 1975 · S/N 28-7510095 N1491CYancey Wesley · Leonardtown, MDBuilt 1976 · S/N 32R-7680297 N1491TGreat Lakes Air Ventures LLC · Mason, MIBuilt 1972 · S/N 28-7205308 N1492TLargo Logistics LLC · Port Orange, FLBuilt 1972 · S/N 28R-7235305 N1494HGriggs Olivia · Sarasota, FLS/N 28R-7703027 N1496HCapital Acquisitions LLC · Atchison, KSS/N 32R-7780163 N1497XTundra Toyo And Heating LLC · Nome, AKBuilt 1975 · S/N 32-7500038 N1498TMurwin Keith T · Douglasville, GABuilt 1972 · S/N 28R-7235307 N1499HMeloney Leeyoung Chase · Peachtree City, GAS/N 28-7725146 N149DCDale Gared W · Hugo, OKS/N 28-2643 N149DTNew Mexico Flying Eagle Inc DBA · Tucson, AZBuilt 2005 · S/N 2844125 N149JLKenyon Terry J · Henderson, ARBuilt 1975 · S/N 28R-7535109 N149LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842192 N14BEBelmont Circle LLC · Virginia Beach, VABuilt 1979 · S/N 28-7911322 N14DJJ&N Management Inc · Wilmington, DEBuilt 2001 · S/N 2843497 N14DP5b Aviation LLC · Duncan, OKBuilt 1970 · S/N 28-5738 N14DWBurnett Timothy S · Birmingham, ALS/N 32R-7887023 N14KCAviation Engineering Technical Services Inc · Savannah, GABuilt 1979 · S/N 28R-7931082 N14LNSchultz Tim J · Mount Juliet, TNBuilt 1971 · S/N 28-7225043 N14NRPiper Capital Investments LLC · Denton, TXBuilt 1965 · S/N 28-20614 N14PZDivinia Dustin · Bonham, TXS/N 28-11050 N14RWJohnston Jeffrey T · Ramsey, MNS/N 28-10217 N14YBKate Air LLC · Southlake, TXBuilt 1979 · S/N 28-7990461 N15002Registered aircraftBuilt 1972 · S/N 28-7205315 N15003Flying Untethered LLC · Saranac Lake, NYBuilt 1972 · S/N 28-7225548 N15005Oliver Everett G · No Mankato, MNBuilt 1972 · S/N 28-7205316 N15006Corio Salvatore J Jr · Warwick, RIBuilt 1972 · S/N 28R-7235315 N15007Marshall County Flying Club Inc · Lacon, ILBuilt 1972 · S/N 28R-7235316 N15010Van Buskirk James R · Tuttle, OKS/N 28-7225550 N15013Krantz Gwendolyn A · Advance, NCBuilt 1972 · S/N 28R-7235318 N15015Harbison Ricky W · Guymon, OKS/N 32-7240133 N1501TRegistered aircraftBuilt 1972 · S/N 32-7240127 N1501XBowser William K · Ball Ground, GABuilt 1975 · S/N 28-7505235 N15021Brandywine Flight School · West Chester, PABuilt 1972 · S/N 28R-7235319

Back to AD 87-08-08 R3