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.

N7502NBemidji Aviation Services Inc · Bemidji, MNS/N LD-391 N750BBJjs3 LLC · Baton Rouge, LABuilt 1983 · S/N BB-1169 N750RCLuke & Payton LLC · Marianna, ARS/N LJ-640 N751KCJ A Peterson Enterprises Inc · Shawnee Mission, KSBuilt 1980 · S/N LJ-887 N754CACarver Aero LLC · Davenport, IABuilt 2009 · S/N BB-2013 N754TWCentral Virginia Aviation Inc · North Dinwiddie, VAS/N LJ-754 N757BAWw Air LLC · Burwell, NEBuilt 1984 · S/N LJ-1097 N757RK757 Romeo-Kilo Aviation LLC · Corpus Christi, TXFirst renewal noticeBuilt 1987 · S/N BB1278 N7586ZGould Aviation LLC · Aberdeen, SDBuilt 1985 · S/N FA71 N758KCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1967 · S/N LJ316 N75GDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-83 N75LVCook Childrens Health Enterprises · Fort Worth, TXS/N BB-1075 N75LW4t Aviation LLC · Maypearl, TXBuilt 1973 · S/N LW-75 N75MSDodson International Parts Inc · Rantoul, KSBuilt 1983 · S/N LA204 N75NDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1967 · S/N LM-57 N75PGDasch Air LLC · Alamo, CABuilt 1995 · S/N LJ-1390 N75RSCentral Virginia Aviation Inc · North Dinwiddie, VAS/N LJ-533 N75VDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1968 · S/N LM-103 N75ZDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-61 N76Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-11 N761KCentral Virginia Aviation Inc · Petersburg, VABuilt 1968 · S/N LJ-426 N762PPAway Air LLC · Wilmington, DES/N BB-1897 N764CACarver Aero LLC · Muscatine, IABuilt 1991 · S/N BB-1408 N767MCMonument Aviation LLC · North Chesterfield, VABuilt 1973 · S/N LJ-595 N769SLSanta Ynez Films · Malibu, CABuilt 1980 · S/N LA-20 N76GMDodson International Parts Inc · Rantoul, KSS/N LJ-498 N76QDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-15 N76RTEmax LLC · Perry, GABuilt 1970 · S/N LB-27 N77Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-12 N770ABAgb Management Inc · Warrenton, VABuilt 1981 · S/N BE121 N770DReynolds Roger David · Key West, FLBuilt 1980 · S/N BE-90 N770VFGuardian Flight LLC · Lewisville, TXBuilt 2001 · S/N LJ-1641 N770WTS&R Transportation I LLC · Wilmington, NCS/N BB-1925 N771CWJ&R Aviation Holdings LLC · Tampa, FLBuilt 1978 · S/N BE-52 N771MGEaglemed LLC · Wichita, KSBuilt 1998 · S/N BB-1636 N771PADodson International Parts Inc · Rantoul, KSBuilt 1983 · S/N LJ-1055 N771PDGuardian Flight LLC · Lewisville, TXBuilt 2001 · S/N LJ-1635 N772JBJsb Aviation LLC · Wichita Falls, TXBuilt 2001 · S/N LJ-1652 N773Uniquorne LLC · Helena, MTBuilt 1983 · S/N LA-214 N773CPDbs Aviation LLC · Wilmington, DEBuilt 1986 · S/N BB-1260 N773PWTexair LLC · Hereford, TXBuilt 1979 · S/N LJ-864 N773SDSouth Dakota Department Of Transportation · Pierre, SDBuilt 1995 · S/N LJ1413 N773TPState Of Of Utah · Salt Lake City, UTBuilt 2000 · S/N BB-1722 N77477International Air Services Inc Trustee · Carson City, NVS/N BT-10 N774AKBering Air Inc · Nome, AKS/N BB-1797 N774LKElite Medical Air Transport LLC DBA · Santa Teresa, NMBuilt 2002 · S/N BL-145 N775DMGeneration Jets LLC · Denison, TXBuilt 1978 · S/N LJ-764 N776RWReliance Well Service Inc · Magnolia, ARBuilt 2006 · S/N BB-1926 N7779VAircraft Fidelity Corp Trustee · Dover, DEBuilt 2001 · S/N BB-1770 N777EB7eb Aviation LLC · Dallas, TXBuilt 1979 · S/N LJ-863

Back to AD 87-22-01 R1