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.

N7199HDynamic Avlease Inc · Bridgewater, VABuilt 1971 · S/N LU-07 N7199LDynamic Avlease Inc · Bridgewater, VABuilt 1971 · S/N LU-09 N7199SDynamic Avlease Inc · Bridgewater, VABuilt 1972 · S/N LU-11 N719GLAlpine Aviation Inc · Provo, UTBuilt 1984 · S/N UB-19 N719PBGraber Joel · Collins, MSBuilt 1973 · S/N LJ-594 N71KACentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1973 · S/N LJ-578 N71WBEagle Air Transport Inc · Ottawa, ILBuilt 1974 · S/N LW-127 N72Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-7 N7200ZUas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N U-219 N7202YBoeing Co · Berkeley, MOBuilt 1984 · S/N FA-12 N7203CUas Transervices Inc · Boca Raton, FLBuilt 1985 · S/N UB-28 N7206EEt Aviation LLC · Alcoa, TNS/N LA-234 N7207EBemidji Aviation Services Inc · Bemidji, MNBuilt 1984 · S/N U-223 N7209WUas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N U-224 N720AMKing Eagle II LLC · Grand Blanc, MIBuilt 1999 · S/N BB-1663 N7212PBemidji Aviation Services Inc · Bemidji, MNBuilt 1984 · S/N U-220 N721RFEdgington Transport LLC · Livermore, CABuilt 1982 · S/N LA-190 N72213Skyline Aviation Services LLC · Miramar, FLBuilt 1994 · S/N LJ-1450 N722BRB&L Aviation LLC · North Myrtle Beach, SCBuilt 2000 · S/N BB-1701 N722TRJamair LLC · Poland, OHBuilt 1981 · S/N BB-938 N722VBCopacetic Air LLC · Rutledge, TNS/N LJ987 N7230HAb Aviation LLC · Johns Island, SCBuilt 1985 · S/N LJ-1113 N724AAAlbright Insurance Holdings Inc · Burlington, NCBuilt 1998 · S/N BB-1632 N724KHCloud Nine Corp · Batesville, INBuilt 1995 · S/N LJ-1426 N7250TEpic Aviation Inc · New Smyrna Beach, FLBuilt 1985 · S/N BB-1237 N725ARTrr Land & Livestock LLC · Douglas, WYBuilt 1979 · S/N LJ-879 N727BCue Capital LLC · Edmond, OKBuilt 2000 · S/N BB-1734 N727BWAcc4m LLC · Augusta, GABuilt 1981 · S/N BB-861 N727MTKryptonite Industries LLC · Golden, COBuilt 1978 · S/N LW-271 N728DWNela Management Services LLC · Monroe, LABuilt 2004 · S/N LJ-1713 N729AKDavis Aviation Inc DBA · Brandon, MSBuilt 1988 · S/N FA106 N72GLPalm Development Partners LLC · Lexington, TNS/N LJ1261 N72JDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-72 N72LDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-19 N72TGSouthland Entertainment Inc · Wrightsville Beach, NCBuilt 1990 · S/N LJ-1252 N73Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-8 N730HMIsr Aviation LLC · Wilmington, DEBuilt 1999 · S/N BB-1648 N734CBGuardian Flight LLC · Lewisville, TXBuilt 1998 · S/N LJ-1508 N735KSouth Seattle Community College · Seattle, WABuilt 1965 · S/N LJ-35 N73MCCoastal Helicopters LLC · La Verne, CABuilt 1973 · S/N LJ-600 N73PGFirst Financial Bankshares Inc · Abilene, TXBuilt 2000 · S/N LJ-1607 N73PHBronson Air LLC · Thebes, ILBuilt 1979 · S/N LJ-875 N744PCCorzon Aircraft Sales LLC · Highland Park, ILBuilt 2003 · S/N BB-1815 N745EALaurel Road Properties LLC · Morehead City, NCBuilt 2001 · S/N BB-1745 N747EMSal Holdings LLC · Helena, MTBuilt 1983 · S/N BE-136 N747VWHammer Aviation LLC · Miami, FLBuilt 1967 · S/N LD-360 N748LBAnfinson Aviation Inc · Williston, NDBuilt 1990 · S/N BB-1374 N74AWMonroe County Sheriff'S Office · Key West, FLS/N BB-1233 N74RARoyal Air Freight Inc · Waterford, MIBuilt 2004 · S/N BB-1869 N75Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-10

Back to AD 87-22-01 R1