AD 97-01-13
Registered aircraft · 54,837
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:97-01-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:97-01-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:97-01-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:97-01-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.
N33272Explorco LLC · Evergreen, CON33273Dahl Neil A · Arlington, TXN33274Cooker Brian M · Gold Hill, NCN33277Niebuhr Bradley A · Morriston, FLN3327DWelborn Mark G · Boonville, NCFirst renewal noticeN3327GWhitewater Aviation Inc · Harrison, OHN3327RLyman Gregory A Trustee · Traverse City, MIN3327SDavis Blake A · Bellevue, TXN3327TFriedl Robert Stephen Jr · Mammoth Lakes, CAN3328DAcme Aircraft Leasing Mt LLC · Kalispell, MTN3328ENorthwoods Air LLC · Orono, MEN33291Skyways Aviation Inc · Wilmington, DEN33296Mob Aviation USA LLC · Auburndale, FLN33297Skinner Marvin L · Mansfield, TXN33299Business Jet Services Inc · Apopka, FLN3329DWarren Mark W · Arlington, WAN3329ERichards Erick F · Stamford, TXN3329FFerguson Ryan L · Fort Collins, CON3329UDirectional Holdings LLC · Missoula, MTN332DGRaymond Jeffrey R · Fairbanks, AKN332JCS&S Aircraft Inc · Bennington, VTN332JRAdair Lawrence L Jr · Fountain Run, KYN333Grullon Guarocuya · Van Buren Twp, MIN3330DState Of Alaska · Kodiak, AKN3330EJarco Air LLC · Fitchburg, MAN3330FEmk Trans LLC · The Dalles, ORN3330JDownwind Three Six LLC · Murfreesboro, TNN3330UWolford Alyson · Bonney Lake, WAN3330YTighe Joseph E · Kingsland, TXN3331DKramer Donald J · Buffalo, MNN3332SFluckey Gary T · Homer, AKN3332TWilliams Darryl L · Medina, OHN3332UMing Greg A · Guymon, OKN3333JUrban Aviation Services Inc · Paxton, MAN3333MFun Tickets LLC · Manchester, MEN3333YDeville Charles D · Clinton, LAN3334DRedford Daniel A · Wasilla, AKN3334EJarmer Ryan F Trustee · San Diego, CAN3334TBaumann Keith A · Fairfield, ILN3334YHarless Richard K · Battle Mountain, NVN3335DWilson Zane D · Fairbanks, AKN3335FSocorro Meraz · El Paso, TXN3335UFogle Kenneth J · Chagrin Falls, OHN3336SVancil Todd · Justin, TXN3336TBirch Point Ventures LLC · Virginia, MNN3337Chay James M · Kent, WAN3337DSmooth Air LLC · Camas, WAN3337EAltitude Aviation LLC · Lenoir, NCN3337FAerolife Aviation LLC · Knox, INN3337SBeery Bruce M · Lakeland, FL
Back to AD 97-01-13