Registered aircraft · 333

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

N100CCSeneca Tank · Des Moines, IABuilt 1982 · S/N 425-0170 N101CANorton Energy Drilling LLC · Lubbock, TXS/N 425-0142 N101HLPapoose Air II LLC · Wilmington, DEBuilt 1981 · S/N 425-0056 N101PSJtech Solutions Inc · San Ramon, CABuilt 1982 · S/N 4250108 N102ADEpic Crew LLC · Fort Worth, TXBuilt 1983 · S/N 4410311 N105FC4j Air LLC · Newark, DEBuilt 1981 · S/N 425-0094 N10FZAirflair Inc · Maurice, IABuilt 1981 · S/N 425-0117 N111KULot-A-Go Six LLC · Polson, MTBuilt 1985 · S/N 425-0226 N112CZDelta Delta Papa LLC · Fort Lauderdale, FLBuilt 1981 · S/N 441-0233 N114HLRegistered aircraftBuilt 1981 · S/N 425-0110 N1188G207rs LLC · Santa Feon, NMBuilt 1984 · S/N 425-0202 N11MMN11mm LLC · Anchorage, AKBuilt 1979 · S/N 441-0105 N1212CDodson International Parts Inc · Rantoul, KSBuilt 1985 · S/N 441-0346 N1222BKelly Douglas E · Bethesda, MDBuilt 1980 · S/N 425-0060 N1223BConquest Technology Associates LLC · San Rafael, CAS/N 425-0201 N12268Ballard Aviation Inc · Newton, KSS/N 425-0227 N1227JPrairie Dog Aviation Lc · Wichita, KSBuilt 1985 · S/N 425-0229 N123HLEfinance LLC · Wichita, KSS/N 441-0010 N1262TColdsteel Holdings LLC · Naples, FLBuilt 1987 · S/N 4250236 N128EZN128ez LLC · Anchorage, AKBuilt 1979 · S/N 441-0128 N137CDMlg Aviation LLC · Houston, TXS/N 425-0220 N13NWCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1979 · S/N 441-0090 N146GWBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 425-0146 N147WFConsolidated Aero LLC · Gibsonville, NCBuilt 1981 · S/N 425-0119 N14BMPeyton James L II · Granby, COBuilt 1981 · S/N 425-0076 N14FJLand Safely LLC · Tinton Falls, NJBuilt 1980 · S/N 441-0118 N14NWCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1980 · S/N 4410171 N14TA35th Terrace LLC · Wellington, FLBuilt 1980 · S/N 441-0168 N15DBN15db LLC · Bend, ORBuilt 1981 · S/N 441-0278 N15STSpray Brothers Aviation LLC · Great Bend, KSBuilt 1981 · S/N 425-0140 N168MARunway Vineyards LLC · Santa Maria, CAS/N 4250155 N169MFCommodore Aviation LLC · Palm Beach, FLBuilt 1981 · S/N 441-0221 N16FJRaven Air LLC · Hotchkiss, COBuilt 1978 · S/N 441-0067 N16NWCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1978 · S/N 441-0045 N17CPN17cp Corp Trustee · Wilmington, DES/N 425-0156 N17TJSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 441-0165 N18481Snowball Medical Inc · Knoxville, TNBuilt 1981 · S/N 425-0105 N1880APlaneco LLC · Lincoln, NEBuilt 1978 · S/N 441-0080 N188DFArc Holdings LLC · Grand Junction, IABuilt 1984 · S/N 425-0188 N191MGN191mg LLC · New Bedford, MAS/N 4410315 N200EKBw Air LLC · Pierre, SDBuilt 1984 · S/N 425-0205 N207RS5m Consulting LLC · Uvalde, TXBuilt 1984 · S/N 4250195 N207SSTm Aero LLC · Riverview, FLBuilt 1980 · S/N 441-0136 N20WEEvans Phyllis H Trustee · Riverside, CABuilt 1980 · S/N 441-0160 N226MKN226mk Corp Trustee · Wilmington, DEBuilt 2018 · S/N 441-0209 N22CG316 Extreme LLC · Basalt, COBuilt 1979 · S/N 441-0119 N233PJLwkimber Interests Management LLC · Houston, TXBuilt 1986 · S/N 441-0362 N233RCRico Marketing Corporation · Flint, MIBuilt 1982 · S/N 441-0263 N239JPTj Air Holdings Inc Trustee · Wilmington, DES/N 425-0016 N23NWCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1978 · S/N 441-0066

Back to AD 85-25-11