Registered aircraft · 303

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-02-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-02-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-02-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-02-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-02-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-02-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.

N3050NLuttrell Robert E III · Mckinney, TXS/N 1547 N3056RHassenpflug Derek G · Cincinnati, OHS/N 1598 N30573Dentdel Inc · Wilmington, DEBuilt 1994 · S/N 1615 N3058VN5237l LLC · Oswego, NYS/N 1617 N311DR7427 Aviation LLC · Clovis, CAS/N 955 N313DTKemp Martin K · Leesburg, VAS/N 59 N319AVBermudez Reinaldo · Doral, FLS/N 707 N31TBRusso Christopher · Huntsville, TXS/N 483 N324BBN324bbjf Inc Owner Trustee · Wilmington, DEBuilt 1999 · S/N 647 N341TBWil Aviate LLC · Merced, CAS/N 1696 N343TBQualitair LLC Trustee · MichelstadtBuilt 1994 · S/N 1697 N345TBInternational Air Services Inc Trustee · Carson City, NVS/N 1914 N351TBLetter Ride LLC · Woodbury, MNBuilt 1995 · S/N 1708 N356GTPadre Bendice Este Vuelo LLC · Groveton, TXBuilt 1998 · S/N 1850 N356TBSky West Aviation Inc Trustee · Albuquerque, NMS/N 1709 N358TBSlezak David · Davison, MIBuilt 1995 · S/N 1716 N366TBLouie Co Pilot LLC · Liberty Lake, WAS/N 1724 N377CValiair Limited Company Trustee · Casper, WYBuilt 2005 · S/N 2222 N37RKWardrop Donald Alexander · Bay Springs, MSBuilt 1985 · S/N 482 N388JGBeggins Thomas J · Madison, CTBuilt 2000 · S/N 2021 N38TBDrier Properties LLC · Gillett, ARBuilt 1985 · S/N 491 N397TBLiberty Industries LLC · Washington, DCBuilt 1997 · S/N 1804 N398SAGembala Gary L · Strongsville, OHBuilt 1998 · S/N 1824 N399YAWadyac Inc Trustee · Wilmington, DES/N 2175 N411JSPenniless Pilots Inc · Bowie, MDS/N 1139 N41PWWhitehouse Thomas · Bethlehem, GABuilt 1985 · S/N 527 N41TBMarikan LLC · Strongsville, OHS/N 485 N421TBHale Concepts LLC · Marietta, OHBuilt 2002 · S/N 2081 N422EKWebster Eric Thomas · Austin, TXS/N 1249 N422ENHicks Avionics LLC · Dawson, GAS/N 1241 N42TGMurray Frederick D · Evans, GAS/N 684 N456TBValentine David L · Katy, TXBuilt 1999 · S/N 1911 N4734KLenox Robert P · Palo Alto, CABuilt 1984 · S/N 400 N4736EBarstow Barnstormers LLC · Midland, MIBuilt 1984 · S/N 415 N47SGStanley Kristy · Coldwater, MSBuilt 1984 · S/N 428 N500TMcconnell Harold L · Cavalier, NDS/N 624 N500TBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1990 · S/N 1195 N501LFMilchev Valentin · New Hampton, NHBuilt 1995 · S/N 1758 N51TBSorenson Gary Trustee · Storden, MNBuilt 1985 · S/N 488 N525DVSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1987 · S/N 763 N52JGMalloy Marc · Fletcher, NCS/N 670 N543GTPathfinder Aero Services LLC · Sheridan, WYS/N 2190 N54TWQualitair LLC Trustee · MichelstadtS/N 745 N55342Dienwiebel Thomas · Santa Cruz, CAS/N 1183 N554Valiair Lc Trustee · Casper, WYS/N 1232 N55424Delgado LLC · Brandon, VTS/N 1228 N5543TTrinidad Flyers LLC · Fort Meade, MDBuilt 1991 · S/N 1233 N5545LRegistered aircraftBuilt 1991 · S/N 1234 N5547JWinds Aloft LLC · Huntsville, ALS/N 1242 N5548CBme&G Enterprises LLC · State College, PAS/N 1247

Back to AD 87-22-02 R1