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.

N601DMR & G Aviation LLC · Hazlehurst, GABuilt 1979 · S/N LJ825 N602DH2nd Amendment Wholesale Inc · Grand Forks, NDBuilt 1973 · S/N LW-44 N603PACentral Virginia Aviation Inc · Petersburg, VABuilt 1968 · S/N LJ-403 N6045STexoma Building Services LLC · Kingston, OKBuilt 1979 · S/N BE-65 N605EAChip Aviation LLC · South Pittsburg, TNBuilt 1981 · S/N LA-129 N605JDM2driver LLC · Midland, TXBuilt 1996 · S/N BB-1555 N606CMSeagull Aviation LLC · Larkspur, CABuilt 1981 · S/N LA-163 N606PC988sl Aviation LLC · Ridgeland, MSBuilt 1980 · S/N LJ-938 N607FJGuardian Flight LLC · Lewisville, TXBuilt 2006 · S/N BB-1963 N608FBVortex Education Management LLC · El Cajon, CABuilt 1979 · S/N LJ-878 N60BABemidji Aviation Services Inc · Bemidji, MNS/N LW-79 N60CDynamic Avlease Inc · Bridgewater, VABuilt 1968 · S/N LM-11 N60FXAmeriflight Management Services Inc · Orlando, FLBuilt 1968 · S/N LC-312 N60NKKirchhoefer John D · Orlando, FLBuilt 1969 · S/N LC-328 N60RADodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N BT-7 N60TJArk Leasing Inc · Newport Beach, CABuilt 1977 · S/N BE-21 N60UCAlpine Aviation Inc · Provo, UTS/N UC-60 N60VPGuardian Flight LLC · Lewisville, TXBuilt 1998 · S/N LJ-1516 N610TANorth Flight Aero Med · Traverse City, MIBuilt 1998 · S/N BB-1609 N6111VSfh Inc · Fargo, NDBuilt 2004 · S/N LJ-1711 N611CRV J Coleman And Son · Ackerly, TXBuilt 1990 · S/N LJ-1234 N611SDGreen Diamond One LLC · Knoxville, TNBuilt 1988 · S/N BB-1307 N612FN612f LLC · Henderson, TNBuilt 1989 · S/N LJ1192 N613GAGaf Holdings Inc · Visalia, CABuilt 2005 · S/N BB-1909 N613GGNcp Equipment LLC · Wilmington, DEBuilt 1998 · S/N LJ-1506 N613RFB R S Leasing Inc · Wilmington, DEBuilt 1983 · S/N LJ-1068 N613TAWild Blue Aviation LLC · Wilmington, DEBuilt 1997 · S/N BB-1581 N615AASkydive San Joaquin Valley Inc · Bakersfield, CABuilt 1967 · S/N LJ-298 N61698Wildfire Aviation LLC · Wilmington, DES/N LJ-1698 N616RPCapling Aviation LLC · Labelle, FLBuilt 1989 · S/N FA-181 N617MMCal-Ore Life Flight LLC · Brookings, ORBuilt 2000 · S/N LJ-1587 N617RMMontana Sky Assets LLC · Helena, MTS/N LJ-1095 N618United States Department Of Interior · Boise, IDBuilt 1990 · S/N BB-1378 N6182AA&R Air Inc · Hinsdale, ILBuilt 1994 · S/N BB-1484 N6190SAir Logistics LLC · Savannah, GAS/N LJ-1702 N619DDPark Avenue Group Inc · Stuart, FLBuilt 1980 · S/N BE-92 N619PAPafford Air Of Mississippi LLC · Ruston, LABuilt 1993 · S/N BB-1458 N61APTrewhitt Jamie Mcmahan · Pacific Palisades, CAS/N BB-1192 N61DNDn2 Aviation LLC · Fernandina Beach, FLBuilt 1992 · S/N BB-1438 N61GNGuardian Flight LLC · Lewisville, TXS/N LJ-1421 N61PCN61pc Leasing LLC · Ponca City, OKBuilt 1994 · S/N BB-1483 N61PEHc4 LLC · Fair Play, SCBuilt 1983 · S/N BB-1132 N61QDynamic Avlease Inc · Bridgewater, VABuilt 1968 · S/N LM-92 N61THBlue Heron Aviation LLC · Orwigsburg, PABuilt 1984 · S/N FA-17 N61UCAlpine Aviation Inc · Provo, UTBuilt 1989 · S/N UC61 N6207FAir New England LLC · Portsmouth, NHBuilt 1982 · S/N LJ-1017 N620TWStrega Ventures LLC · Boca Raton, FLBuilt 1974 · S/N LW-107 N620WESouthwest Aviation Inc · Marshall, MNBuilt 1977 · S/N LJ-743 N621EMN621em LLC · Ocala, FLBuilt 1981 · S/N LA-123 N623BBAirshares Incorp · Petersburg, VABuilt 1967 · S/N LJ-277

Back to AD 87-22-01 R1