Skip to content

Registered aircraft · 177

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

N1004BJames R Cartillar III · Hickory Ridge, ARS/N 501-0022 N1004FAeroag LLC · Portland, INBuilt 1988 · S/N 502-0025 N1006YG B Aerial Applications Inc · Slaton, TXS/N 502-0031 N1007WAir Cover LLC · Frankford, MOBuilt 1988 · S/N 502-0032 N1008FMid-Atlantic Aircraft Leasing LLC · Wilmington, DEBuilt 1988 · S/N 502-0033 N1009LSouther Field Aviation Inc · Americus, GABuilt 1989 · S/N 502-0036 N10114Hoppe Air LLC · Beaman, IAS/N 502-0043 N10125North Delta Ag Aviation LLC · Sledge, MSBuilt 1989 · S/N 502-0047 N10126Quiver River Flying LLC · Doddsville, MSBuilt 1989 · S/N 502-0050 N10129Parrish Aerial Services LLC · Wilmington, DEBuilt 1989 · S/N 502-0051 N1012ZBuffalo Aviation LLC · Monette, ARBuilt 1989 · S/N 502-0044 N10185Oli Grow LLC · Baskin, LABuilt 1989 · S/N 502-0063 N1019SBuffalo Ridge Airspray LLC · Milbank, SDS/N 502-0066 N1021BBeachy Flying Service LLC · Whittington, ILBuilt 1989 · S/N 502-0062 N1022NBoyle Flying Service Inc · Boyle, MSS/N 502-0071 N1025AAas LLC · Ovid, MIBuilt 1990 · S/N 502-0075 N1035LSwope Cattle Inc · Anahuac, TXS/N 502-0080 N1036WSouther Field Aviation Inc · Americus, GABuilt 1989 · S/N 502-0041 N1055FWbd Flying LLC · Sondheimer, LABuilt 2011 · S/N 502A-2751 N105TPBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 502A-3352 N118FAFarm Air Inc · Astoria, ILS/N 502A-3607 N1224WMaco Aviation Inc · Dayton, WABuilt 1998 · S/N 502A-0496 N133HFTlc Flying Inc · Colfax, WAS/N 502-0101 N1502UCentral Ag Air LLC · Marion, KSBuilt 1991 · S/N 502-0139 N1507KDakota Air Spray LLC · Huron, SDBuilt 1991 · S/N 502-0142 N15102Moes Crop Dusting Service Inc · Marysville, CABuilt 1991 · S/N 502-0146 N1515GKidd Clifford L · Monahans, TXBuilt 1991 · S/N 502-0152 N15189Tri Rotor Spray & Chemical · Ulysses, KSBuilt 1991 · S/N 502-0155 N1519ZFlatland Aviation LLC · Indianola, MSBuilt 1991 · S/N 502-0156 N1529ERoth Aerial Spraying LLC · Milford, NEBuilt 1991 · S/N 502-0161 N1529HMiller Aviation Inc · Norton, KSBuilt 1992 · S/N 502A-0158 N1539XRba LLC · Kimberly, IDBuilt 1992 · S/N 502A-0166 N1540SArthur Aviation LLC · Arthur, NDBuilt 1992 · S/N 502-0171 N1547UR & D Leasing Inc · Lemoore, CABuilt 1992 · S/N 502A-0183 N1556WPrecissi Flying Service Inc · Lodi, CABuilt 1992 · S/N 502-0185 N15588Slikker Flying Service Inc · Buttonwillow, CABuilt 1992 · S/N 502A-0175 N1558URba LLC · Kimberly, IDBuilt 1992 · S/N 502A-0188 N166MMCrider Flying Service Inc · Swifton, ARBuilt 1999 · S/N 502A-0572 N186DCAir Care Inc · Lamar, COBuilt 1992 · S/N 502-0186 N198LAVissair LLC · Rigby, IDBuilt 1993 · S/N 502-0198 N2003BBrylen 502 LLC · Dumas, TXBuilt 2011 · S/N 502A-2741 N205CGSeewald Jeffrey W · Great Bend, KSBuilt 2006 · S/N 502A-2603 N205RMLissie Flying Service Inc · Lissie, TXBuilt 1998 · S/N 502A-0491 N244PWAdams Aerial Solutions LLC · Decatur, ILBuilt 2024 · S/N 502A-3494 N247LFWilliamsburg Air Service Inc · Kingstree, SCBuilt 2022 · S/N 502A-3395 N249LABank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 502A-3049 N254LAObriens Flying Service Inc · Iowa, LABuilt 2016 · S/N 502A-3054 N256MSBuck N Aviation Inc · Fort Worth, TXNon-citizen corporation, flight hours not reportedBuilt 2021 · S/N 502A-3281 N270TWMattern Rodney M DBA · Dawson, NDBuilt 2022 · S/N 502A-3367 N273GCO'Briens Flying Service Inc · Iowa, LABuilt 2016 · S/N 502A-3073

Back to AD 2000-14-51