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.

N48QDynamic Avlease Inc · Bridgewater, VABuilt 1981 · S/N BL48 N48WPlatina Investment Corporation · Oklahoma City, OKBuilt 1977 · S/N LW-254 N490DMFlying Colors Air Parts Inc · Leesburg, FLS/N LJ468 N490TXHosell Aviation LLC · Rome, GABuilt 1980 · S/N LA-50 N491JVCessna 205 LLC · Austin, TXBuilt 1993 · S/N LJ-1349 N4925TAir Services LLC · Spokane, WAS/N BB-1870 N492GPBank Of Utah Trustee · Salt Lake City, UTBuilt 1989 · S/N BB-1326 N4947MKca Of Montana LLC · Helena, MTBuilt 1978 · S/N LJ-780 N494BHEvergreen Holdings LLC · Missoula, MTBuilt 1981 · S/N LA-135 N494MAKing Lenny LLC · Fairview Park, OHBuilt 1986 · S/N FA108 N495NMCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1978 · S/N LJ-781 N495YEaglemed LLC · Wichita, KSBuilt 2004 · S/N LJ-1707 N497RBAircraft Registration Inc Trustee · KematenBuilt 1993 · S/N FA-228 N499CZN499cz LLC · Milwaukee, WIBuilt 1969 · S/N U-81 N499LGear Robert Lee III · Paradise Valley, AZBuilt 1961 · S/N LC-87 N49FBFlying Bullet LLC · Grand Island, NEBuilt 1988 · S/N FA-153 N49JPSumner Properties LLC · Somersworth, NHBuilt 1990 · S/N LJ1243 N49RDynamic Avlease Inc · Bridgewater, VABuilt 1975 · S/N BD02 N49UCUas Transervices Inc · Boca Raton, FLBuilt 1989 · S/N UC49 N4QLFremont Motor Company Inc · Lander, WYBuilt 1981 · S/N BB-942 N4RANyerges James · Midland, TXBuilt 1969 · S/N LB-4 N4RYCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1964 · S/N LJ-8 N500EQTxsd Holdings LLC · Amarillo, TXBuilt 1994 · S/N LJ-1387 N500FEBeech Transportation Inc · Eden Prairie, MNBuilt 1986 · S/N BB-1212 N500HGEm Aviation Ka B200 LLC · Atlanta, GAS/N BB-1954 N500LPMeri Acquisitions LLC · Kilgore, TXS/N BB-1141 N501DUWaterside Holdings LLC · Knoxville, TNBuilt 1980 · S/N LA-82 N501MSDodson International Parts Inc · Rantoul, KSBuilt 1974 · S/N LJ-626 N503AWCsi Aviation Inc · Albuquerque, NMBuilt 1995 · S/N BB-1514 N503CBCtb Inc · Goshen, INBuilt 1982 · S/N LJ-997 N504CBPlane Leasing LLC · Wilmington, DEBuilt 1974 · S/N LW-125 N504ECAlpha Tango LLC · Little River, SCBuilt 1995 · S/N BE-120 N504GFOxford Advisory Aviation LLC · Orlando, FLBuilt 1983 · S/N BB-1156 N50525Kansas State University · Salina, KSS/N LJ159 N505AWCsi 135 Division LLC · Albuquerque, NMBuilt 2001 · S/N BB-1755 N505MWBoeing Co · Renton, WAS/N LW-155 N505SPN505sp LLC · Ontario, CABuilt 1996 · S/N BB-1538 N506AFCreedeair LLC · San Antonio, TXBuilt 1979 · S/N LJ-843 N5078EBemidji Aviation Services Inc · Bemidji, MNBuilt 1963 · S/N LF-76 N5078GFresh Air Aviation Inc · Charlevoix, MIBuilt 1960 · S/N LF-8 N5078NBemidji Aviation Services Inc · Bemidji, MNS/N LF-16 N5078UBemidji Aviation Services Inc · Bemidji, MNBuilt 1962 · S/N LF-32 N5079EBemidji Aviation Services Inc · Bemidji, MNS/N LF-52 N507GFBallard Aviation Inc · Newton, KSBuilt 2001 · S/N BB-1778 N5080GQuinlan John H DBA · Claxton, GABuilt 1962 · S/N LF-35 N5080HBemidji Aviation Services Inc · Bemidji, MNBuilt 1961 · S/N LF-27 N5080LBemidji Aviation Services Inc · Bemidji, MNBuilt 1962 · S/N LF-59 N508SKMagnolia Logistics Of Ms LLC · Flowood, MSBuilt 1985 · S/N FA-78 N5092SGreat Plains Communications LLC · Blair, NEBuilt 2002 · S/N BB-1802 N509FPPerdue Farms Inc · Salisbury, MDS/N BB-1886

Back to AD 87-22-01 R1