Skip to content

AD 2018-03-03 R1

Registered aircraft · 1,770

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

N425DCLola Air LLC · Reno, NVBuilt 1983 · S/N 425-0185 N425DDAir Flair Inc · Maurice, IABuilt 1981 · S/N 425-0083 N425DHElectronic Concepts Inc · Eatontown, NJBuilt 1981 · S/N 425-0066 N425DKDtt Holdings LLC · Kalispell, MTBuilt 1981 · S/N 425-0086 N425DRAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1984 · S/N 4250199 N425DVVerner David W · Mcalester, OKBuilt 1985 · S/N 425-0232 N425EQueen Bee Air Specialties Inc · Rigby, IDBuilt 1981 · S/N 425-0096 N425EMVfr Air LLC · Tifton, GABuilt 1982 · S/N 425-0164 N425ETTexas Eco Services Inc · Fort Worth, TXBuilt 1981 · S/N 425-0072 N425EZBilbo Foster Holdings LLC · Lubbock, TXS/N 425-0099 N425FSkyfarm LLC · La Jolla, CAS/N 425-0058 N425FZN425fz Corp Trustee · Wilmington, DEBuilt 1981 · S/N 425-0059 N425GCResiak LLC · Middleton, WIBuilt 1981 · S/N 425-0027 N425HBBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 425-0073 N425HDDodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N 425-0113 N425HJApd Development LLC · Palatine, ILBuilt 1984 · S/N 425-0169 N425JBCentral Aviation LLC · Sebring, FLBuilt 1981 · S/N 425-0043 N425JESaturn International LLC · Cheyenne, WYBuilt 1981 · S/N 4250008 N425JGDiamond Vogel Inc · Orange City, IABuilt 1981 · S/N 425-0128 N425JHConquest 425jh LLC · Bow, WABuilt 1981 · S/N 425-0124 N425JTPikes Peak Flyers Llp · Colorado Springs, COBuilt 1981 · S/N 425-0129 N425KCWheels Up Aviation LLC · Mount Horeb, WIBuilt 1982 · S/N 425-0174 N425KDJ G Management Systems Inc · Grand Junction, COBuilt 1984 · S/N 4250203 N425KERio Brazos Aviation LLC · Waco, TXBuilt 1985 · S/N 425-0231 N425KKKobet Keith · Northville, MIBuilt 1983 · S/N 425-0134 N425KSSwja LLC · Haymarket, VABuilt 1981 · S/N 425-0102 N425LAPlane Training LLC · Rapid City, SDBuilt 1981 · S/N 425-0092 N425LCGlyde Aviation LLC · Canton, MABuilt 1981 · S/N 4250054 N425MLRocket Air LLC · Carson City, NVBuilt 1981 · S/N 425-0123 N425NCSch Aviation Inc Trustee · NorfolkBuilt 1984 · S/N 425-0219 N425NPGec Air LLC · Sellersburg, INBuilt 1985 · S/N 4250224 N425PJSouth Georgia Aviation LLC · Tifton, GABuilt 1982 · S/N 425-0157 N425RAReunionaire Corp · Dallas, TXBuilt 1981 · S/N 425-0107 N425REAccutherm Refrigeration Inc · Seal Beach, CABuilt 1982 · S/N 425-0167 N425RFSaphire Air LLC · Utica, NYS/N 425-0147 N425RMGospel Ministries International Inc · Collegedale, TNBuilt 1983 · S/N 425-0180 N425SBLyddon Aero Center Inc · Liberal, KSBuilt 1980 · S/N 425-0017 N425SFFowler Aircraft Sales And Leasing Inc · Newark, OHBuilt 1981 · S/N 425-0037 N425SRTwin Wells Fuel LLC · Carlsbad, NMS/N 425-0133 N425TBScott Squared LLC · Lindale, TXS/N 425-0068 N425TCRons Air Service Inc · Two Buttes, COS/N 425-0014 N425TFArminair Leasing LLC · Dover, DEBuilt 1981 · S/N 425-0143 N425TJAddie Air Inc · Bridgeport, TXBuilt 1981 · S/N 425-0114 N425TPRc Construction Co · Greenwood, MSBuilt 1984 · S/N 425-0213 N425TTN425tt Corp Trustee · Wilmington, DEBuilt 1981 · S/N 425-0044 N425TVPaine Conquest I LLC · Redmond, WAS/N 425-0176 N425TWConquest 425tw LLC · Floresville, TXBuilt 1982 · S/N 425-0161 N425TXContinental Forwarding Services Inc · Laredo, TXBuilt 1981 · S/N 4250039 N425WBBagdasarian Walter DBA · El Cajon, CAS/N 4250184 N425WDRegistered aircraftS/N 425-0130

Back to AD 2018-03-03 R1