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.

N323HADale Aviation Inc · Rapid City, SDBuilt 1979 · S/N LW-323 N323PXFehrs Aviation LLC · Seminole, TXBuilt 2002 · S/N BB-1803 N3246SInsync Investments LLC · Dover, DEBuilt 1999 · S/N LJ-1576 N324SAAtlantic Air Services 71991 Inc · Largo, MDBuilt 1989 · S/N UC-94 N3250VK & J Air Services Ltd · Midland, TXBuilt 1995 · S/N BB-1523 N325RRCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1967 · S/N LJ-289 N3262REaglemed LLC · Wichita, KSBuilt 1999 · S/N LJ-1562 N3263CEaglemed LLC · Wichita, KSBuilt 1996 · S/N LJ-1432 N3263NGuardian Flight LLC · Lewisville, TXBuilt 1999 · S/N LJ-1563 N326CAAlpine Aviation Inc · Provo, UTBuilt 1970 · S/N U-135 N326KWBering Air Inc · Nome, AKBuilt 1990 · S/N BB1360 N327BADamandan Air Enterprises LLC · Gallatin, TNBuilt 1980 · S/N BE99 N327LCNeptune Agricultural Group Inc · Vero Beach, FLS/N BB1427 N327MEReach Co LLC · Hughson, CABuilt 1987 · S/N FA-127 N329GSAugusta Aviation Inc · Hilton Head Island, SCBuilt 1992 · S/N LJ-1320 N32BAPittsburgh Skydiving Jump Plane LLC · Mercer, PABuilt 1969 · S/N LJ-475 N32LJCrocker LLC · Missoula, MTBuilt 1981 · S/N BB-993 N32PDynamic Avlease Inc · Bridgewater, VABuilt 1966 · S/N LM-31 N32RHPor Aviation LLC · Huntersville, NCBuilt 1990 · S/N LJ-1268 N330AFUas Transervices Inc · Boca Raton, FLBuilt 1985 · S/N UB-38 N330AVUas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N U-230 N330DBBlueskyways LLC · Bend, ORBuilt 1999 · S/N LJ-1542 N330VAlcovy Mountain Venture LLC · Monroe, GABuilt 1978 · S/N LJ-811 N331AFUas Transervices Inc · Boca Raton, FLBuilt 1985 · S/N UB-44 N332DEMetro Aircraft Co · Bloomington, MNBuilt 1975 · S/N LJ-674 N332JSSouth Coast Lumber LLC · Brookings, ORBuilt 2006 · S/N BB-1938 N332LCUc132 LLC · Dallas, TXS/N UC132 N332MSLowcountry Aviation Company Brokerage LLC · Walterboro, SCBuilt 1982 · S/N LJ1023 N333QTQ Flight LLC · Bernardsville, NJBuilt 2000 · S/N BB-1702 N333TLBrad And Jill Janecke LLC · Pierre, SDBuilt 1982 · S/N LJ-999 N333WTWright Aero Inc · Saint Cloud, MNBuilt 1980 · S/N LA-91 N333XPRichard L Richards Pa Trustee · Coral Gables, FLBuilt 2000 · S/N LJ-1609 N338AFAmeriflight LLC · Dallas, TXBuilt 1989 · S/N UC57 N339KAChenango Aviation LLC · Dallas, TXBuilt 1980 · S/N LW-339 N33FRCharles L Fridge III Pc · Houston, TXBuilt 1978 · S/N LW-299 N33KCCarvair LLC · Salem, ORBuilt 1984 · S/N FA-35 N33SBPittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1967 · S/N LJ-252 N341WBAndrews Worldwide LLC · Amarillo, TXBuilt 2005 · S/N BB-1885 N342ERSoutheast Aviation LLC · Oxford, MSBuilt 1987 · S/N LJ-1156 N343KKTreeline Transportation Inc · Vance, ALBuilt 1978 · S/N BE-46 N346AFAmeriflight LLC · Dallas, TXBuilt 1989 · S/N UC71 N346BALwcr Transportation Inc · Minot, NDBuilt 1999 · S/N BB-1653 N347AFAmeriflight LLC · Dallas, TXBuilt 1989 · S/N UC66 N349ARAcademy Resources LLC · Taos, NMBuilt 2002 · S/N BL-144 N34AKUas Transervices Inc · Boca Raton, FLBuilt 1969 · S/N U-105 N34CEFirst Call Home Health Agency LLC · Salem, ORBuilt 1981 · S/N LJ-932 N34HAHarper Aerospace LLC · Murfreesboro, TNS/N LM-120 N34LTPaper Boys LLC · Dover, DEBuilt 1992 · S/N BB-1437 N34MFDavis Aviation Inc · Brandon, MSBuilt 1975 · S/N LW-163 N34RZUas Transervices Inc · Boca Raton, FLBuilt 1991 · S/N UC-151

Back to AD 87-22-01 R1