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.
N184PSStrama Aviation LLC · Ocala, FLN184XTitan Island Aviation LLC · Houston, TXN1852EMarshall Dennis Ray Jr · Pottsboro, TXN1852HI Fly Stl LLC · Saint Louis, MON1856HVieman John D · Owensville, MON1862TBradley Max T II · West Plains, MON1865SPima County Board Of Supervisors · Tucson, AZN186THSandy Hook Aviation LLC · Sandy Hook, MSN1873HBlue Canoe Aviation LLC · Chicago, ILN1879ERaw Racing Inc · Puyallup, WAN1879HRegan Robert C · Kent, WAN187WWOsprey Aviation LLC · Riva, MDN1886HGoodwin Joseph N · Grass Valley, CAN188GWBrown Die Casting & Manufacturing Inc · Royse City, TXN188SRRogers Steven Trustee · Ogden, UTN1894EDelvest LLC · Grosse Pointe, MIN189MKS2ar Aviations LLC · Lantana, FLN189MWWilliamson Aviation Inc · Tullahoma, TNN18BKShandog Air LLC · Ashland, KYN18EGBoanco Inc · Lafayette, INN18MRMorey Airplane Co Inc · Middleton, WIN18SGBennett Jeannette DBA · Joiner, ARFirst renewal noticeN18TN18t Ltd · Wilmington, DEN18TCAviotti Inc · Henderson, NVN18VUVincennes University · Vincennes, INN1905B605 Aviation LLC · Aberdeen, SDN1905ERusso Louis A Jr · Houston, TXN1918EGuano Air LLC · Palmetto Bay, FLN1919JValiair Lc Trustee · Casper, WYN1919LSmith Sydney O · Lithonia, GAN191CTBessemer Plywood Corp · Bessemer, MIN191RAnderson Harold E · Phoenix, AZN1920EHappy Trails Flight Training & Charters LLC · Helena, MTN1925GEfi Technology Inc · Cave Creek, AZN192AFWarren E Mack LLC · Minneapolis, MNN193DC310 Charter LLC · Zanesville, OHN1942GBas Part Sales LLC · Greeley, CON1944EHans Construction LLC · Lititz, PAN1944GBas Part Sales LLC · Greeley, CON1946GPartwin421 LLC · Greenwich, CTN1956Sturges George S Jr · Bakersfield, CAN196CAHyannis Air Service Inc DBA · Hyannis, MAN196FSTechnical Education Services Inc · Virginia Beach, VAN196RLunsford Joel T · Jasper, TXN196TCClements Dylan A · Burlington, WIN1987GPhillips Michael M · Angleton, TXN1995GHarris Justin R · Hico, TXFirst renewal noticeN19AFBegley Edward R · Glasgow, KYN19DBDcs Air LLC · Pulaski, WIN19DJLewis Landon Jon · Hope, ND
Back to AD 90-02-13