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.

N208MLAngelo Sorce Md Pllc · Dandridge, TNBuilt 1962 · S/N LF-34 N20FDGilmer Aircraft Leasing LLC · Wilmington, DEBuilt 1998 · S/N LJ-1528 N20FWUas Transervices Inc · Boca Raton, FLBuilt 1969 · S/N U-111 N20RADepartment Of The Air Force · Hill Afb, UTBuilt 1985 · S/N UB-42 N20SA Paradise Repo LLC · Nokomis, FLBuilt 1978 · S/N LW-267 N20WPMoser Aircraft Service LLC · Huntington, INBuilt 1977 · S/N LJ-738 N210ECState Of Tennessee · Nashville, TNBuilt 1984 · S/N LJ-1070 N211CGAzul Air LLC · Dover, DES/N LW-101 N211LGStaggerwing Holdings LLC · Englewood, COBuilt 2000 · S/N BB-1732 N212HCHcc Air LLC · Las Vegas, NVS/N BB-1791 N212LWPf Aviation LLC · Carl Junction, MOBuilt 2001 · S/N BB-1766 N213AVDodson International Parts Inc · Rantoul, KSS/N U-213 N213DBMarshall Air Systems Inc · Charlotte, NCBuilt 1993 · S/N BB-1450 N213MCMcr Aviation LLC · Austin, TXBuilt 1991 · S/N FA-216 N214GBPterodactyl Inc · Wilmington, DEBuilt 1999 · S/N BB-1668 N214PNavajo Nation · Window Rock, AZBuilt 1991 · S/N LJ-1293 N214SBSan Bernardino Co Sherriffs Dept · San Bernardino, CABuilt 1975 · S/N BC-02 N214SCAzul Air LLC · Dover, DEBuilt 1976 · S/N LW-96 N214TPPlatinum Aviation LLC · Monte Sereno, CAS/N BB1855 N215HCPlane Lease Co · Minneapolis, MNS/N BB-1848 N216CSAlpine Aviation Inc · Provo, UTBuilt 1983 · S/N U-216 N217LGStaggerwing Holdings LLC · Crystal Lake, ILBuilt 1995 · S/N BB-1501 N218DZRed Brick Summit LLC · Wilmington, DEBuilt 1981 · S/N BB-925 N218GJJaztec LLC · Ooltewah, TNBuilt 1982 · S/N BB-1013 N218PDMoye Robert W · Saint Augustine, FLS/N LF-48 N218SLAlpine Aviation Inc · Provo, UTBuilt 1990 · S/N UC113 N2192LSiller Brothers Incorporated · Yuba City, CABuilt 1976 · S/N LW-192 N219JGInternational Jet Aviation Services Inc · Centennial, COS/N LJ-1470 N219RMMoro Aircraft Leasing Inc · Two Rivers, AKBuilt 1988 · S/N UC-13 N219VPAlpine Aviation Inc · Provo, UTBuilt 1984 · S/N UB-14 N21BDSouthern Illinois Helicopters LLC · Marion, ILBuilt 1983 · S/N BB-1115 N21CGN21cg Leasing LLC · Ponca City, OKBuilt 1989 · S/N BB-1346 N21DZBravo Hotel LLC · Lewes, DEBuilt 1977 · S/N BC-32 N21FWUas Transervices Inc · Boca Raton, FLBuilt 1969 · S/N U-117 N21KGSuncrest Aviation LLC · Labelle, FLBuilt 1981 · S/N LA-149 N21RZUas Transervices Inc · Boca Raton, FLBuilt 1990 · S/N UC-106 N220KWAirselect LLC · West Point, IABuilt 1983 · S/N BB-1120 N220RARoyal Air Freight Inc · Waterford, MIBuilt 1983 · S/N BB-1130 N220VTExec III LLC · Maineville, OHBuilt 1983 · S/N BB-1177 N221BHUas Transervices Inc · Boca Raton, FLBuilt 1981 · S/N U-168 N221MMGordon Truck Centers Inc · Pacific, WABuilt 1988 · S/N FA-161 N222AGKryptonite Industries LLC · Golden, COBuilt 1981 · S/N LA-159 N222CYBlue Star Gas Fleet Services Co · Santa Rosa, CABuilt 1990 · S/N BB-1370 N222KCU S Army - Owner · New Century, KSBuilt 1979 · S/N BC-68 N223BHUas Transervices Inc · Boca Raton, FLBuilt 1981 · S/N U-173 N223CABemidji Aviation Services Inc · Bemidji, MNBuilt 1983 · S/N U-200 N223JRBierlein Aviation LLC · Midland, MIBuilt 1985 · S/N FA-45 N223MWWhiskey Tango LLC · Midland, TXBuilt 2007 · S/N BB-1967 N223RCSailfish Aviation LLC · Little Mountain, SCBuilt 1985 · S/N FA-58 N223TPAviapa LLC · Doylestown, PABuilt 1989 · S/N BB-1348

Back to AD 87-22-01 R1