OpenAirDocs.org
AD 99-15-04 R1

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

N888HLPermian Basin Blue Sky Inc · Odessa, TXBuilt 1985 · S/N 46-8508081N88RARusso Mark · Stevensville, MTBuilt 1996 · S/N 4636034N891AWColonial Aviation LLC · Morristown, NJBuilt 1989 · S/N 4622024N895CMJlb Leasing LLC · Mequon, WIBuilt 2023 · S/N 4636826N896SJTumbleweed Aviation LLC · Great Bend, KSBuilt 1996 · S/N 46-36033N89PMLittle Dreams Aviation LLC · Washingtn Twp, MIBuilt 2013 · S/N 4636613N8SZFinch Stanley F · San Marcos, TXBuilt 1987 · S/N 4608079N900MASdp Air Inc · Memphis, TNBuilt 2007 · S/N 4636406N901MAWings Of Ber LLC · Fort Payne, ALBuilt 2000 · S/N 46-36301N904TMLake House Resort LLC · Prescott, AZS/N 46-8608044N905EMLakeshore Aviation LLC · Denver, NCBuilt 2018 · S/N 4636728N9080XNoldin John · Griffith, INS/N 46-8608035N9083UNashville Malibu Partners LLC · Hendersonville, TNBuilt 1986 · S/N 46-8608039N9083ZCalder Brothers Corp · Greenville, SCBuilt 1986 · S/N 4608003N9090JDieppa Pablo F · North Charleston, SCBuilt 1986 · S/N 46-8608049N9090NPmt Flyers LLC · Amarillo, TXFirst renewal noticeBuilt 1986 · S/N 46-8608050N9095SPowers Land Management Service Inc · Lyons, INBuilt 1986 · S/N 46-8608061N9098UGlobal T & E Inc · Mcallen, TXBuilt 1986 · S/N 4608025N9099DRegistered aircraftBuilt 1986 · S/N 46-8608066N90ERSkyes Aviation Outfitters LLC · Laguna Vista, TXBuilt 1999 · S/N 4636243N90SEKelly James D II · San Francisco, CABuilt 1989 · S/N 4622041N9100UFly Mcble LLC · Huntsville, ALBuilt 1986 · S/N 4608011N9100ZExpress Industries LLC · Prescott Valley, AZS/N 4608014N9101QSims Air LLC · Cincinnati, OHBuilt 1986 · S/N 4608015N9102HTrw International LLC · Glendora, CABuilt 1986 · S/N 4608018N9109MAr Malibu LLC · Gassville, ARBuilt 1985 · S/N 46-8608006N910RHDelaurentis Robert · Oak Harbor, WABuilt 1984 · S/N 46-8408066N9111PBas Part Sales LLC · Greeley, COBuilt 1987 · S/N 4608084N9113ZKenmore Crew Leasing Inc Owner Trustee · Bellingham, WABuilt 1986 · S/N 4608045N9114NOutlier Mt LLC · Kalispell, MTBuilt 1986 · S/N 4608048N9117JBlue Skies Malibu LLC · San Diego, CABuilt 1987 · S/N 4608052N911JCAva Leasing LLC · Bay Harbor Islands, FLBuilt 2021 · S/N 4636783N9120YEast West Aviation LLC · Joaquin, TXBuilt 1985 · S/N 46-8608010N9121XCarter Associates Inc · Burr Oak, MIBuilt 1987 · S/N 4608094N9122LBerman Joshua E · Nashua, NHBuilt 1987 · S/N 4608096N9122NAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1987 · S/N 4608097N9122YCook Auction Co Inc · Clinton, MOBuilt 1985 · S/N 46-8608011N9123VEschenbach Ralph F · Woodside, CAS/N 4608060N9124YAerobox LLC · Seattle, WABuilt 1985 · S/N 46-8608012N9125BStockton Aviation Group LLC · Stockton, CABuilt 1987 · S/N 4608068N9127ZPalmy LLC · Lander, WYBuilt 1987 · S/N 4608059N9131QTanlin LLC · Chicago, ILBuilt 1987 · S/N 4608082N9131XWomack Equipment Leasing LLC · Terre Haute, INBuilt 1987 · S/N 4608083N9131ZBaczewski Gary · Fredericksburg, TXS/N 4608103N9133GConsolidated Consulting Inc · Norfolk, NEBuilt 1988 · S/N 4608111N9133VPlane Fun Inc Tr Trustee · Snellville, GABuilt 1988 · S/N 4608112N9146RZoll Ross H · Glen Allen, VABuilt 1988 · S/N 4608138N9153WSasapaw LLC · Prosper, TXS/N 4622012N915EDSqa Services Inc · Pls Vrds Est, CABuilt 2006 · S/N 4636397N9160XHoneywell Aerospace US LLC · Phoenix, AZBuilt 1989 · S/N 4622046
Back to AD 99-15-04 R1