Skip to content

Registered aircraft · 657

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:91-25-08-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:91-25-08-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:91-25-08-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:91-25-08-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:91-25-08-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:91-25-08-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.

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 N425WFRegistered aircraftAssigned, pending cancellationS/N 4250207 N425WGR Ritchie Lp · Odessa, TXBuilt 1981 · S/N 425-0030 N425WLAirmann LLC · Mount Sterling, KYBuilt 1984 · S/N 4250197 N425WTIrwin International Inc · Corona, CAS/N 425-0175 N425XR B Stevenson Aviation LLC · Chandler, AZBuilt 1982 · S/N 425-0122 N425XPK&M Aviation LLC · Aberdeen, SDBuilt 1981 · S/N 425-0064 N425YAriel Leasing LLC · Aberdeen, SDBuilt 1984 · S/N 425-0209 N427CCBoard Of Trustees Of Southern Illinois University · Carbondale, ILBuilt 1977 · S/N 421C0348 N427JMPittman James L · Destin, FLS/N 421C0103 N429GMResendiz Marcelino · Alamo, TXBuilt 1982 · S/N 421C1251 N42AWWilliams C Allen · Longview, TXBuilt 1981 · S/N 425-0136 N42HMSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N 421C0683 N42MLRegistered aircraftS/N 421C0639 N435CEPacific Fbo Properties LLC · Santa Barbara, CABuilt 1981 · S/N 425-0042 N438EL1 Stop Sod & Landscaping Inc · Orlando, FLBuilt 1977 · S/N 421C0274 N43AWWilliams C Allen · Longview, TXBuilt 1985 · S/N 425-0225 N43BMDodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N 421C1224 N440DL421 Partners LLC · Crown Point, INBuilt 1983 · S/N 421C1401

Back to AD 91-25-08 R1