AD 90-15-15 R1
Registered aircraft · 826
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:90-15-15-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:90-15-15-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:90-15-15-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:90-15-15-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.
N842CSSomerville James P · Anchorage, AKN842LBBlair Lynward E · Headland, ALN845TAirborne Perspectives LLC · Fort Collins, CON84JDBeving Charles D · Garden City, SDN8505Lunetta Peter Joseph Jr · Niskayuna, NYN8528Somerville Billy J · Newport, NCN8548Collum Aviation LLC · Milton, FLN85GPRay Hardee · Dupont, WAN861ACGuglietta Glenn W · Payson, AZN8622VHoneycutt Aviation Inc · Olivehurst, CAN8625VLemaire Jonathan D · Taunton, MAN862ACMadelaire LLC · Bow, NHN86573Phoenix Aviation Services Inc · Miami, FLN86578Halpin Aviation · Eden Prairie, MNN86585Birchler Judy A · Indianapolis, INN86595Coker Janie K · Tyler, TXN86607Yellow Decathlon LLC · Algonquin, ILN8663Ireland Kel · Fredericksburg, TXN86630Pressley Aviation LLC · New London, NCN86637Stohr Beuford G · Woden, IAN8665VMaisel Chad L · Plano, TXN86682Twardokens Eva M · Aptos, CAN8687VCollum Aviation LLC · Milton, FLN8693VMichael A Levenhagen · North Fort Myers, FLN86948Guglietta Jon R · Harwinton, CTN86953Madden Russell · Graford, TXN86954Breaking Wind LLC · Alabaster, ALN86974Qualitair LLC Trustee · MichelstadtN8698VNine 8 Victor Tailshare LLC · Kalispell, MTN86CYDawson J Stewart · Celina, TXN86RAAcrodocs LLC · Tallahassee, FLN86RTInverted Aviation Inc · Walnut Cove, NCN86WJWalbridge James S · Mill Hall, PAN8702VArrowhead Aeromotive Services LLC · Hoodsport, WAN87038Thompson Christopher S · Senoia, GAN8707VBeckerwilliam M Trustee · Foristell, MON870ACSessler Jay L · Sumner, WAN870WTPesson Russell · Covington, LAN8719VBluemel Steve · Auburntown, TNN8724Fairhope Decathalon LLC · Fairhope, ALN872ACDoto Paul Jr · Santa Rosa, CAN873ACAcfc LLC · Oak Brook, ILN8751VClemens Robert Lyle · Oklahoma City, OKN8753VScott Gorski Aviation Aerobatics · Bothell, WAN8759VSmetters Jeffrey L · Crystal Lake, ILN878ACDecathlon LLC · Herndon, VAN87WAMann Ronald L · Pound Ridge, NYN8804Hail Jerry D · Keatchie, LAN88149Cheshire Brad F · Flower Mound, TXN88268Neidert Melvin E · Ulysses, KS
Back to AD 90-15-15 R1