Registered aircraft · 896

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:99-15-04-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:99-15-04-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:99-15-04-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:99-15-04-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:99-15-04-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:99-15-04-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.

N135USJohn Hale · Temple, TXBuilt 1987 · S/N 46-08078 N139LFLgd Properties Inc · Wylie, TXBuilt 2011 · S/N 4636505 N13PCGj Aviation LLC · Mountain Lakes, NJBuilt 1984 · S/N 46-8408081 N141SBCk Aviation LLC · Bismarck, NDBuilt 1999 · S/N 4636244 N1438TFreedom Flyers II LLC · Islip, NYBuilt 2014 · S/N 4636615 N143LAMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2009 · S/N 4636459 N143PPBolch James R · Vero Beach, FLBuilt 2015 · S/N 4636664 N146BUSaltwater Aviation LLC · Friday Harbor, WABuilt 1984 · S/N 46-8408057 N146MSMagnolia Partners Aviation LLC · Lockesburg, ARBuilt 1984 · S/N 46-8408032 N146NCHills Jason · Bothell, WABuilt 1998 · S/N 4636176 N146RFValiair Limited Co Trustee · Casper, WYBuilt 2011 · S/N 4636502 N146ZFNo Boundry Airplane LLC · Council Bluffs, IABuilt 1984 · S/N 46-8408002 N14BCSrdo Advanced Wound Care Associates Pllc · Dallas, TXS/N 4636014 N14CXVortac LLC · Traverse City, MIBuilt 1988 · S/N 4608107 N14EFInternational Air Services Inc Trustee · Carson City, NVBuilt 1988 · S/N 4622009 N14PCAlooment LLC · Las Vegas, NVBuilt 1989 · S/N 4622027 N151TMBehel Bobby O · Tuscumbia, ALBuilt 2010 · S/N 4636467 N155MAOne Zero Three Six Papa LLC · Florence, SCBuilt 2019 · S/N 4636743 N15EFEastern Aviation Fuels Inc · New Bern, NCBuilt 1999 · S/N 4636195 N15XJSt Express LLC · El Segundo, CABuilt 2022 · S/N 4636796 N1630WN O Good LLC · Wade, NCBuilt 2011 · S/N 4636508 N168GFC2c LLC · Christiansted, VIS/N 4636189 N16LTClausen Frederik M · Lake Forest, ILBuilt 1988 · S/N 4608130 N171MElevated Holdings Inc · Newport Beach, CABuilt 2024 · S/N 4636841 N177HCQualitair LLC Trustee · MichaelstadtBuilt 2001 · S/N 4636314 N177MASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1994 · S/N 4622177 N178DBPrm Enterprises Inc · Manchester, NHS/N 4636333 N17NGParmer Construction Company LLC · Terrell, TXBuilt 1987 · S/N 4608074 N181TRPk Financial Consulting LLC · Chandler, AZBuilt 2013 · S/N 4636580 N188KCMalibu Management LLC · Ponte Vedra, FLBuilt 2013 · S/N 4636588 N188LAAvf Flyers LLC · Richmond, VAS/N 4636185 N188LGMyskinmedspa LLC · Rockledge, FLBuilt 1989 · S/N 4622043 N189MHSpirit Life Inc · Morrison, COBuilt 1998 · S/N 4636159 N18JMDixon John F · Hayden, IDBuilt 1999 · S/N 4636229 N18JSAdelaar Holdings LLC · Missoula, MTBuilt 2016 · S/N 4636702 N190CCWayside LLC · Wilmington, DEBuilt 1984 · S/N 46-8408045 N1921JPjet Holdings LLC · Chattanooga, TNBuilt 2013 · S/N 4636606 N1937BPiper Aircraft Inc · Vero Beach, FLBuilt 2025 · S/N 4636858 N193SFBlue Castle Properties LLC · Littleton, COBuilt 2012 · S/N 4636567 N194PMDye David A · Point Clear, ALBuilt 1993 · S/N 4622146 N19500Wright Bros Flying Club LLC · Lewes, DEBuilt 1994 · S/N 4622163 N195JGN195jg Aviation LLC · Port Republic, NJBuilt 1994 · S/N 4622173 N1972MN1000 LLC · St Simons Island, GABuilt 2014 · S/N 4636631 N1972XAds Investment Firm LLC · Pacifica, CABuilt 2012 · S/N 4636524 N197LABg Family Limited Partnership · Edinburg, TXBuilt 1997 · S/N 4636098 N197MAShore Air LLC · Trappe, MDBuilt 1997 · S/N 4636079 N197PMRegistered aircraftBuilt 1997 · S/N 4636086 N1987MPace Air LLC · Odessa, TXBuilt 2025 · S/N 4636872 N19JPSheldon Law Pllc · Scottsdale, AZBuilt 1997 · S/N 4636119 N1WLGray William Loyd Jr · Nashville, TNBuilt 2002 · S/N 4636337

Back to AD 99-15-04 R1