AD 90-02-13
Registered aircraft · 3,863
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-02-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:90-02-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:90-02-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:90-02-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.
N2619LAircraft Holding Solutions LLC Trustee · Newark, DEN2619Z4j Air LLC · Cartersville, GAN261ALCkm Aircraft Holdings I LLC · Mandan, NDN261REPeterson Randy J · Sonoma, CAN262MCAerospace Trust Management LLC Trustee · Wilmington, DEN2631SAsplundh Eric P · Bryn Athyn, PAN2632BHeubeck Associates Inc · New York, NYN2634KKoeppel Steven Lynn Trustee · Mckinney, TXN26355Fay Andrew T · San Marcos, TXN26370Gv Air Inc · Medford, ORN2637DMcanulla Robert · Trabuco Canyon, CAN2638CPickett Joseph C · El Paso, TXN2638YLawson Sean E · Lexington, KYN2640FLaguna Verde Leasing Inc · Wilmington, DEFirst renewal noticeN2641ZTfs Air LLC · Loveland, CON2642CMuniz Elmer · Port Saint Lucie, FLN2643YCompany Plane LLC · Wisconsin Rapids, WIN2643ZPolizzi Christopher I · Peachtree City, GAN2649ZHyannis Air Service Inc · Hyannis, MAN264DCAirdvm LLC · Rcho Sta Marg, CAN26514Hyannis Air Service Inc · Hyannis, MAN2651SHyannis Air Service Inc · Hyannis, MAN26533Txoperation LLC · Fort Scott, KSN2655CSmith Lionel J · Ironton, MON26560Rockslide Analytics Inc · Livermore, CAN2657GB & K Leasing Inc · Nantucket, MAN2657NLoreto Aviation LLC · Wahoo, NEN26588Golden Aero LLC · Tarpon Springs, FLN2658ZVirtue Genetics LLC · Cedar Rapids, IAN265PCSilver Eagle II LLC · Carson City, NVN265RGHerron Aviation Group LLC · Dexter, MIN2660UUnited Front Holdings LLC · Laguna Hills, CAN2664FWisconsin Aviation Inc · Watertown, WIN2664LAce Airways LLC · Quincy, WAN2666DDrda Enterprises LLC · Denver, CON2666JA-Leasing · Dayton, OHN2668ASouthern Aircraft Consultancy Inc Trustee · Casper, WYN26692Fields Douglas P Jr · Brooklyn, NYN2669NWilliamson Benjamin J · Morgan Hill, CAN2671CHouchen Chris F · Palmer, AKN2672CClipper Sky LLC · Las Vegas, NVN2673BM & N Of Alabama LLC · Magnolia Springs, ALN2673DAircraft Guaranty Corp Trustee · Oklahoma City, OKN2674CTri County Sprayers Inc · Hamlin, TXN2676BKero Jet Corporation · Montgomery, TXN2676RStauter Michael D · Idabel, OKN2676YHands Holdings · Newark, DEN267CAHyannis Air Service Inc DBA · Hyannis, MAN2688DB2 Air LLC · Pierre, SDN2688MAlcyone Trust Corp Trustee · Wichita, KS
Back to AD 90-02-13