Registered aircraft · 1,915

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-22-01-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:87-22-01-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:87-22-01-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:87-22-01-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:87-22-01-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:87-22-01-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.

N133GAJab Aire LLC · Wilmington, DEBuilt 1989 · S/N BB1321 N134BABemidji Aviation Svc Inc · Bemidji, MNBuilt 1964 · S/N LD-202 N135AAKentucky King Air LLC · Hazard, KYBuilt 1985 · S/N LJ-1112 N135BABemidji Aviation Services Inc · Bemidji, MNBuilt 1962 · S/N LD-68 N135MKRio Frio Leasing Co LLC · Houston, TXBuilt 1984 · S/N FA-3 N136PAX-Press Charter Service Inc · Longview, TXBuilt 1975 · S/N LJ662 N137BABemidji Aviation Services Inc · Bemidji, MNBuilt 1970 · S/N U137 N139JBQuay Ventures LLC · Alto, TXBuilt 1979 · S/N BE-81 N139SCNew Ulm C90 LLC · Marshall, MNBuilt 1979 · S/N LJ868 N13GZGuardian Flight LLC · South Jordan, UTBuilt 2000 · S/N LJ-1590 N140HAxis Transportation Services LLC · Sacramento, CABuilt 2005 · S/N LJ-1753 N140PAJump Plane Of Pittsburgh LLC · Mercer, PABuilt 1967 · S/N LJ-297 N140RLN140rl LLC · Kalispell, MTBuilt 1982 · S/N BT22 N141SMInfinity Aeronautics LLC · Greer, SCBuilt 1984 · S/N FA-23 N142EBFly Me LLC · Mc Gregor, TXBuilt 1982 · S/N BB-1042 N142TPGeorgia Florida Aviation Search Team · Monticello, FLBuilt 1962 · S/N LF-71 N143FWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N LJ-1612 N143TAJrr Motor Sales LLC · Campbellsville, KYBuilt 1984 · S/N BB-1183 N145AFDale Aviation Inc · Rapid City, SDS/N LJ-1721 N146LCSaratoga Homes Of Texas San Antonio LLC · El Paso, TXBuilt 1982 · S/N BB1046 N147LJGuardian Flight LLC · Lewisville, TXS/N LJ-1476 N149CCCianbro Corp · Baltimore, MDS/N FA-145 N149SFAlpine Aviation Inc · Provo, UTBuilt 1991 · S/N UC-149 N14HHDelaware Professional Aviation LLC · Dalton, GABuilt 1988 · S/N BB-1286 N14NGFirst Avenue Management LLC · Savannah, GABuilt 1987 · S/N BB-1276 N14NMDriscoll Health Care Services · Corpus Christi, TXBuilt 1973 · S/N LW-35 N14SBMountain Air Aviation LLC · Jonesville, VAS/N LW-214 N14VDouble D International LLC · Miami, FLS/N LJ-411 N150CNKing Air Investments LLC · Ferriday, LABuilt 1981 · S/N LA-138 N150GWRocinante Air LLC · Cincinnati, OHBuilt 1998 · S/N LJ-1531 N150KJAlpine Aviation Inc · Provo, UTBuilt 1991 · S/N UC-150 N150RLTigress Air III LLC · California, MDBuilt 1982 · S/N BL-50 N150TWCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1973 · S/N LW-50 N150VECarnes 150ve LLC · Wichita Falls, TXBuilt 1975 · S/N LJ-678 N150YDSfh Inc DBA · Fargo, NDBuilt 1997 · S/N BB-1561 N151WTKo Aviation LLC · Wilmington, DEBuilt 1983 · S/N BB-1151 N152WWNardi Greg · Missoula, MTS/N LJ-654 N153GAAlpine Aviation Inc · Provo, UTBuilt 1985 · S/N UB-34 N1544VGuardian Flight LLC · Lewisville, TXBuilt 1994 · S/N LJ-1366 N154GAAlpine Aviation Inc · Provo, UTBuilt 1984 · S/N UB-25 N1552DDodson International Parts Inc · Rantoul, KSBuilt 1989 · S/N LJ-1204 N1552GEast Atlantic Aviation LLC · Edenton, NCBuilt 1989 · S/N LJ-1206 N1553GMccloy Mark · Tatum, NMBuilt 1989 · S/N LJ-1214 N155AVTeton Leasing LLC · Pocatello, IDBuilt 1985 · S/N BB-1216 N155BBRegistration Pending · Greer, SCRegistration pendingBuilt 1997 · S/N BB-1554 N155LSRainair Avionics Services LLC · Albertville, ALS/N LW-286 N1560Davis Aviation Inc · Brandon, MSS/N BC-09 N1568GUas Transervices Inc · Boca Raton, FLS/N UC-58 N156GAlliance Air Parts Acquisitions Corp · Oklahoma City, OKBuilt 1975 · S/N LW-156 N157MHMile Hi Skydivers Inc · Longmont, COS/N LW157

Back to AD 87-22-01 R1