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.

N1212WTwo Drakes Air LLC · Lizella, GABuilt 1994 · S/N LJ-1381 N121BArgo Aviation LLC · Potsdam, NYBuilt 1972 · S/N LW-21 N121DKAutomotive Air II LLC · Belcamp, MDBuilt 2007 · S/N BB-1995 N121JGGo Consultants LLC · Wilmington, DES/N LJ-996 N121JPChoice Farms LLC · Wilmington, DEBuilt 1998 · S/N LJ-1520 N122BKFlying Mixers LLC · Amarillo, TXBuilt 1999 · S/N BB-1651 N122KMerlin Labs Inc · Boston, MABuilt 1976 · S/N LJ-707 N123CHMdi Air LLC · Dothan, ALBuilt 1980 · S/N LA-32 N123FWBhmp King Air LLC · Fort Worth, TXBuilt 2001 · S/N LJ-1655 N123MHBryan-Kennedy LLC · Tulsa, OKBuilt 1974 · S/N LW-104 N123MLNfbn LLC · Scottsdale, AZBuilt 1997 · S/N BB-1587 N124AXAlaska Central Express Inc · Anchorage, AKBuilt 1991 · S/N UC158 N124CMSolomon Mark Trustee · Wilmington, DEBuilt 1984 · S/N FA-24 N124GADriscoll Health Care Services · Corpus Christi, TXBuilt 1982 · S/N BB-1039 N124GPAlpine Aviation Inc · Provo, UTBuilt 1984 · S/N UB-23 N125AXAlaska Central Express Inc · Anchorage, AKBuilt 1988 · S/N UC44 N125BAAlpine Aviation Inc · Provo, UTS/N UB-6 N125KSAlpine Aviation Inc · Provo, UTBuilt 1985 · S/N BL-125 N125NJAircraft Partner Holdings Inc Trustee · Fallbrook, CABuilt 1982 · S/N LJ-1045 N125TECj Brown Express LLC · Graettinger, IABuilt 1992 · S/N BB-1422 N125TSDouble J Aviation Inc · Klamath Falls, ORBuilt 2007 · S/N BB-1993 N126AXAlaska Central Express Inc · Anchorage, AKBuilt 1990 · S/N UC-140 N126MMFreeman Holdings Of West Texas LLC · Medford, ORBuilt 2002 · S/N LJ-1669 N126WAJpg & Aog LLC · Concord, NCBuilt 1984 · S/N LJ1093 N127AXAlaska Central Express Inc · Anchorage, AKBuilt 1989 · S/N UC76 N127BAAlpine Aviation Inc · Provo, UTS/N UB-7 N127MUSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1985 · S/N LJ-1102 N127TXItb Solutions LLC · Palm City, FLBuilt 1981 · S/N BE-106 N127ZWAerolease LLC · Fargo, NDBuilt 1994 · S/N LJ1369 N128ASParker Robert E · Corpus Christi, TXS/N BB-1950 N128AXTailwind Investments LLC · Anchorage, AKBuilt 1989 · S/N UC68 N128JPMontrachet Aviation LLC · Santa Ana, CABuilt 1979 · S/N LA-25 N128VTState Of Missouri · Jefferson City, MOBuilt 1992 · S/N BB-1442 N129LABluebird 2000 LLC · Wilmington, DES/N LJ-129 N129TNGuardian Flight LLC · Lewisville, TXBuilt 2005 · S/N LJ-1742 N12AXEsc-100 Executive Consulting Services LLC · Pharr, TXBuilt 1978 · S/N LW-293 N12GJBuilding Ideas Inc · Los Gatos, CABuilt 1972 · S/N LW-12 N12LACentral Virginia Aviation Inc · Petersburg, VAS/N LW-49 N130GPUas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N U-222 N130RLOscar Charlie II LLC · California, MDBuilt 1980 · S/N BT16 N130SFSuburban Air Freight Inc · Omaha, NEBuilt 1990 · S/N UC-130 N131BABemidji Aviation Svcs Inc · Bemidji, MNBuilt 1966 · S/N LD-297 N131BLLta Group Holdings LLC · Amarillo, TXBuilt 2001 · S/N LJ-1654 N131GPUas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N U225 N131SFSuburban Air Freight Inc · Omaha, NEBuilt 1990 · S/N UC-131 N131SPKauffman Land & Development LLC · Denver, COBuilt 1983 · S/N LA-206 N132BABemidji Aviation Services Inc · Bemidji, MNS/N LD-331 N132HSCentral Virginia Aviation Inc · Petersburg, VABuilt 1972 · S/N LW-8 N132NFlying Cowboys LLC · Merced, CAS/N BB-1053 N133BAAlpine Aviation Inc · Provo, UTBuilt 1986 · S/N UB54

Back to AD 87-22-01 R1