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.

N566ALKgjc Aero LLC · Dow City, IABuilt 1995 · S/N LJ-1415 N566KADalks Leasing Inc · Wilmington, DEBuilt 1989 · S/N FA-201 N567GJDavis Aviation Inc DBA · Brandon, MSBuilt 1974 · S/N LW95 N567MDGem City Properties LLC · Laramie, WYBuilt 1990 · S/N LJ-1231 N568TTAshland Aviation LLC · Ashland, OHBuilt 1997 · S/N BB1568 N569EREastside Rice LLC · Jonesboro, ARBuilt 1981 · S/N LJ-944 N56ACentral Virginia Aviation Inc · Petersburg, VABuilt 1981 · S/N BL-37 N56GMMarianna Logistics LLC · Moro, ARBuilt 2011 · S/N BB-2017 N56HTLissie 6 LLC · Harlingen, TXBuilt 1977 · S/N LW-215 N572WCRegistration Pending · Bullard, TXRegistration pendingBuilt 1981 · S/N BB933 N575CLilly David E · Allentown, PABuilt 1971 · S/N LJ-532 N575FAlpine Aviation Inc · Provo, UTBuilt 1990 · S/N UC-99 N575GUas Transervices Inc · Boca Raton, FLBuilt 1991 · S/N UC-155 N579PSFoxtrot Charlie Inc · Grass Valley, CABuilt 1970 · S/N LJ-496 N57AGMonument Aviation LLC · North Chesterfield, VABuilt 1968 · S/N LJ-343 N57BDynamic Avlease Inc · Bridgewater, VABuilt 1983 · S/N BL-67 N57PASpieker Warren E Jr · Menlo Park, CABuilt 1992 · S/N BB-1444 N580BAN Flight LLC · Kenedy, TXBuilt 2007 · S/N BB1975 N580BKJohn Newcomb Enterprises Inc · Blacksburg, VABuilt 1982 · S/N BB-1000 N580RAGibson & Harrup Leasing LLC · North Dinwiddie, VABuilt 1973 · S/N LJ-580 N580SBott Radio Network Inc · Gravois Mills, MOBuilt 1979 · S/N BE-77 N581EAElite Medical Air Transport LLC DBA · El Paso, TXBuilt 2002 · S/N BL-143 N585ATJr & M Air LLC · San Antonio, TXBuilt 1989 · S/N LJ-1203 N585CEAugusta Aviation Inc · Hilton Head Island, SCS/N BB1194 N586UCMegel Air LLC · Cleveland, GABuilt 1983 · S/N BB-1118 N586YDDodson International Parts Inc · Rantoul, KSS/N LJ1696 N588SAReach Air Medical Services LLC · Santa Rosa, CABuilt 2000 · S/N LJ-1588 N588SDIal Corp · Lewes, DES/N LJ-1663 N58AYAviapa Flight LLC · Doylestown, PABuilt 1995 · S/N BB-1511 N58QDynamic Avlease Inc · Bridgewater, VAS/N BL8 N590SHAlliance Air Parts Acquistions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedBuilt 1977 · S/N LJ-753 N591AWCsi 135 Division LLC · Albuquerque, NMBuilt 1995 · S/N LJ-1397 N595TMRegional Air Group LLC · Windermere, FLBuilt 1990 · S/N LJ-1255 N597BAMca-Plane LLC · Grand Blanc, MIBuilt 2004 · S/N BB1851 N597PGuardian Flight LLC · Lewisville, TXBuilt 2000 · S/N LJ-1597 N598ATWohlford Aviation LLC · Ashland, NEBuilt 1997 · S/N LJ-1499 N599BB3gs Air LLC · Fort Myers, FLBuilt 1976 · S/N LJ-699 N599CZN599cz LLC · Milwaukee, WIBuilt 1969 · S/N U-89 N59ALBilly Ray Casteel LLC · Russellville, ALBuilt 1983 · S/N LA-208 N59BWStandridge Color Corp · Social Circle, GABuilt 1982 · S/N LA-170 N59EKCrosby Richard · Macon, GAS/N LA-58 N59KAParagon Office Services LLC · Dallas, TXS/N LJ-589 N59MDynamic Avlease Inc · Bridgewater, VAS/N BB-1419 N5AETenax Aerospace LLC · Ridgeland, MSS/N BB-1891 N5AHEmpire Air LLC · Indio, CABuilt 1980 · S/N LA-53 N5TADodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N LJ-724 N600ACLowcountry Aviation Co Brokerage LLC · Walterboro, SCBuilt 1976 · S/N LW-185 N600BFCentral Virginia Aviation Inc · Petersburg, VABuilt 1966 · S/N LJ-193 N600RKLc Whitford Co Inc · Wellsville, NYBuilt 2002 · S/N BB-1800 N600WADothan Security Inc · Dothan, ALBuilt 1980 · S/N LA-71

Back to AD 87-22-01 R1