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.

N97DDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1970 · S/N LM-137 N97EBHendee Edd C · Houston, TXBuilt 1986 · S/N FA-97 N97HMEd Santos & Associates LLC Trustee · Wilmington, DES/N LA44 N97SZSierra Zulu Aircraft Management LLC · Wilmington, DEBuilt 1983 · S/N BB1166 N97TDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-127 N97WCHf Air LLC · Hattisburg, MSBuilt 1990 · S/N BB-1382 N97WELawrence Aviation Inc · Austin, TXBuilt 1997 · S/N BB-1586 N980CROcr Aviation · Long Beach, CAFirst renewal noticeBuilt 1979 · S/N LA-23 N980VCN980vc Corp · Wilmington, DEBuilt 1977 · S/N BE19 N981BBGuardian Flight LLC · Lewisville, TXS/N BB-1960 N982RAInbound LLC · Overland Park, KSBuilt 1982 · S/N BB1082 N982SBCal-Ore Life Flight LLC · Brookings, ORBuilt 1998 · S/N LJ-1518 N9838ZN B B S LLC · Kansas City, KSFirst renewal noticeBuilt 1969 · S/N LJ-435 N984ABSunbird Airlines Inc · San Juan, PRBuilt 1989 · S/N UC-84 N984MAExtraordinary Air LLC · Greenville, SCBuilt 1980 · S/N LJ883 N985ABSafford Aviation Service Inc · Coolidge, AZBuilt 1999 · S/N LJ-1561 N987ABDirty Joe Aviation LLC · Windsor, CABuilt 1978 · S/N LW-269 N988KAAero Evanson LLC · Encino, CABuilt 1988 · S/N BB-1295 N988SLInternational Services Management LLC · Heath, TXBuilt 1969 · S/N LJ-438 N988WCE S Wagner Co · Oregon, OHBuilt 1998 · S/N BB-1622 N9898Aspen Air Montana LLC · Albuquerque, NMBuilt 1998 · S/N BB1627 N989LAMha Consulting LLC · Columbia, SCBuilt 1988 · S/N BB-1310 N98ARRyan Gordon Air LLC · Santa Ana, CABuilt 1979 · S/N LJ829 N98HAFew 28 Aviation LLC · Greer, SCBuilt 1980 · S/N LA-34 N98HFValiair Ltd Co Trustee · Casper, WYBuilt 1973 · S/N LW-89 N98KSGuardian Flight LLC · Lewisville, TXBuilt 1997 · S/N LJ-1502 N98PMTcp One LLC · Amarillo, TXBuilt 1974 · S/N LW-131 N98TACentral Virginia Aviation Inc · Petersburg, VABuilt 1978 · S/N BE-56 N98WPWalsh Aviation LLC · Midland, TXBuilt 1997 · S/N LJ1493 N990AFUas Transervices Inc · Boca Raton, FLBuilt 1983 · S/N U-211 N990BMMorse Donald W · Priest Lake, IDBuilt 1980 · S/N LA-70 N990CBB & G Aircraft LLC · Flanders, NJBuilt 1994 · S/N LJ-1362 N990JMCounty Of Galveston · Dickinson, TXBuilt 1966 · S/N LM-17 N990LAMustang West Aero LLC · Midland, TXBuilt 2000 · S/N LJ-1613 N990LSK&A Advisors LLC · Wilmington, DEBuilt 1975 · S/N LJ-677 N990WTAmerican King Air LLC · Escalon, CABuilt 1987 · S/N FA-121 N991AFUas Transervices Inc · Boca Raton, FLS/N U-214 N991AKLake Clark Air Inc · Port Alsworth, AKBuilt 1982 · S/N U-189 N991WWAssured Aviation LLC · Orlando, FLBuilt 1983 · S/N BB-1158 N992AFUas Transervices Inc · Boca Raton, FLBuilt 1983 · S/N U-203 N992AKLake Clark Air Inc · Port Alsworth, AKBuilt 1981 · S/N U-167 N993AKLake Clark Air Inc · Ports Alsworth, AKBuilt 1982 · S/N U-180 N993CBTri-Counties Bank · Chico, CABuilt 1999 · S/N LJ-1550 N994MLGc Air LLC · Knoxville, TNBuilt 1981 · S/N BB-994 N995TXGarbar Organization LLC · Duncan, SCBuilt 1982 · S/N BB1027 N997MDHaynes Aviation LLC · Wetumpka, ALBuilt 1985 · S/N LJ1111 N997SBUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-192 N998AKSafeco Leasing LLC · Port Alsworth, AKBuilt 1988 · S/N BB-1309 N998BWDuplin Aero LLC · Wallace, NCBuilt 1988 · S/N FA-149 N999CZN999cz LLC · Milwaukee, WIBuilt 1969 · S/N U116

Back to AD 87-22-01 R1