AD 96-18-13
Registered aircraft · 1,110
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:96-18-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-18-13')
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:96-18-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-18-13') 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.
N248ECEc Aviation LLC · Lake Oswego, ORN24KTFalcon Type Air LLC · Nashville, TNN24NNWorld Jet Of Delaware Inc · Fort Lauderdale, FLN24SMExecutive Air Solutions Corp · Fort Lauderdale, FLN24ZDNext Wave Aviation LLC · Henderson, NVN250APLone Star Avalanche LLC · Marble Falls, TXN250EXAb Aspen LLC · Opa Locka, FLN250MBNo Layover LLC · Hays, KSN253SCPowderhorn Aviation LLC · Bethany, OKN254ALCorsair Two LLC · Hillsboro, ORN254FSS&S Aviation Management LLC · Waco, TXN254SBHawker 800xp LLC · Fort Lauderdale, FLN255RVSolomon Mark Trustee · Wilmington, DEN256AUnlimited Boat Sales Inc · Page, AZN256VGitsis Nick Trustee · MakatiN257SJN257sj Aviation Corp · Middletown, DEN258UTBurnt Orange Five LLC · Seabrook, TXN259RHAlliance Aviation Group LLC · Wilmington, DEN25EGGarcia Airways LLC · Virginia Beach, VAN25STLewis Garry L · Livingston, LAN25XPRd Airways LLC · Channelview, TXN260LFEthos Aviation LLC · Cleveland, OHN260RCValiair Limited Company Trustee · Casper, WYN260RFHampton Holdings LLC · Atlanta, GAFirst renewal noticeN263SNBlue Skies Hawker LLC · Whitefish, MTN264GVCsc Delaware Trust Co Trustee · Wilmington, DEN264RVHfa Specialty Acquisitions LLC · Boca Raton, FLN265FTSunshine Aero Industries Inc · Crestview, FLN265GCnl Group Services III LLC · Orlando, FLN265HTmfb Transporation LLC · Orlando, FLN265JGShell Mountain Ranch LLC · Cranfills Gap, TXN265WSPortside Aero LLC · Edgewater, NJN266AJMoore Investment Fund LLC · Belmont, OHN268TSExpeditus Holdings LLC · Jacksonville, FLN269TAMadison Ql Partners LLC · Dallas, TXN26BDArkansas Bolt Co · Little Rock, ARN26FNDodson International Parts Inc · Rantoul, KSN26MEJ Jets Inc · Los Angeles, CAN26TNAj Air LLC · Blackwell, OKN270JPLopez Fabio A · Denver, NCN271ACTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN275ERContinuum Aviation LLC · Oklahoma City, OKN277ALAti Jet Inc · El Paso, TXN277MKCasmos LLC · Wilmington, DEN277RSMaize & White Aviation LLC · Youngstown, OHN2787Valiair Lc Trustee · Casper, WYN278TTThunderun Aviation Corp · Buffalo, NYN27AXN27ax LLC · Tulsa, OKN27GAValiair Lc Trustee · Casper, WYN27TZSparrow Aircorp Inc · Dover, DE
Back to AD 96-18-13