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.

N625BWTechnology Service Corp · Arlington, VABuilt 1982 · S/N BB1090 N627KMSpectre Aviation LLC · Dover, DES/N BE-93 N627MGMile High Adventures LLC · Yazoo City, MSBuilt 1989 · S/N FA-197 N62989Uas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-183 N629RPBasche Properties II LLC · Cleveland, OHBuilt 2007 · S/N BB-1984 N62SALta Group Holdings LLC · Amarillo, TXBuilt 1997 · S/N LJ-1472 N62VDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-74 N6300FTenax Aerospace LLC · Ridgeland, MSS/N BB-1865 N634BTurbo Air Charter LLC · Boise, IDBuilt 1974 · S/N BC-19 N635BDodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N BC-49 N636BDavid Aviation Inc DBA · Brandon, MSBuilt 1978 · S/N BC-61 N636TAToth Financial Advisory Corp · Leesburg, VABuilt 2002 · S/N BB-1792 N637WMOhmestede Industrial Services Inc · League City, TXS/N BB-1768 N63978Uas Transervices Inc · Boca Raton, FLBuilt 1981 · S/N U-171 N63LBBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N BB-1894 N640AXAlpine Aviation Inc · Provo, UTBuilt 1987 · S/N UC-1 N640DFWhy Not LLC · Montezuma, KSBuilt 1992 · S/N LJ-1312 N640RJMidwest Executive LLC · Reno, NVBuilt 1985 · S/N LJ-1106 N642TDN642td LLC · Newark, DEBuilt 1978 · S/N LJ-766 N643EAAir Adventures Corp · Charleston, SCBuilt 2001 · S/N LJ-1643 N644JCBic Aviation LLC · Fort Smith, ARS/N LJ-698 N6451DEastern Stearman Inc Trustee · Leesburg, VABuilt 1982 · S/N BB-1009 N648DCSomerset Regional Water Resources · Friedens, PAS/N LD-351 N648DDDashdale Aviation LLC · Fort Dodge, IABuilt 1999 · S/N BB-1683 N6492CSouth River Services LLC · Myrtle Beach, SCBuilt 1982 · S/N LJ-1050 N64CDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-32 N64KAXin Han Aviation LLC · Helena, MTBuilt 1973 · S/N LJ-606 N64UCAlpine Aviation Inc · Provo, UTS/N UC-64 N6531NBering Marine Corp · Seattle, WABuilt 1982 · S/N BB-1081 N653DPBank Of Utah Trustee · Salt Lake City, UTBuilt 1989 · S/N FA-193 N654BADepartment Of The Air Force · Hill Afb, UTBuilt 1982 · S/N BL-54 N6558Metropolitan Airport Authority · Moline, ILS/N 85 N655DFBlue Earth Flying Service LLC · Blue Earth, MNBuilt 1989 · S/N LJ-1197 N655SPNational Aviation Company LLC · Goodlettsville, TNS/N BB-1023 N6563KBeech Transportation Inc · Eden Prairie, MNBuilt 1982 · S/N LJ-1032 N659Gulf South America Air Transport Inc · Mobile, ALS/N LC72 N65CSChallans Robert F · Hesston, KSS/N LC-82 N65MGRegistered aircraftN-number assigned (import), not yet registeredS/N LA-79 N65MSSummey Aviation LLC · Asheville, NCS/N LW-202 N65MTM&M Transit LLC · Winter Park, FLS/N LA-38 N65QAGulf States Air Inc · Bossier City, LAS/N LC-165 N65TADodson International Parts Inc · Rantoul, KSBuilt 1971 · S/N LJ-538 N65TWRound Hound Holdings LLC · Lewes, DES/N BB-902 N65UDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-87 N65VDynamic Avlease Inc · Bridgewater, VABuilt 1968 · S/N LM-113 N66Federal Aviation Administration · Oklahoma City, OKBuilt 1987 · S/N FF-1 N6604LShoals Aircraft Leasing And Operations LLC · Florence, ALS/N BB-1121 N661BADepartment Of The Air Force · Hill Afb, UTBuilt 1982 · S/N BL-61 N662BADepartment Of The Air Force · Hill Afb, UTBuilt 1982 · S/N BL-62 N662JSHughes Leasing Co · Miami, FLBuilt 1976 · S/N LW-176

Back to AD 87-22-01 R1