AD 52-03-01
Registered aircraft · 308
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:52-03-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:52-03-01')
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:52-03-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:52-03-01') 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.
N20615Kretsinger Steven H Trustee · Eugene, ORN20619Smith Happy E · Rogersville, TNN20628Lipsett Rory · Lancaster, PAN20631Levine James David · Mentor, OHN20632Hagerstown Aviation Museum Inc · Hagerstown, MDN20641Gonzales Donald M · Columbia Station, OHN224DBBongiovanni Joseph T · Ocala, FLN2302Schmidt Aaron B · Auburn, ALN232EThomson Scott R · Street SomersetN24FMCoon Robert E · Warrenville, ILN25327Neal Sean Edward · Freehold, NYN25329Hargreaves William A · Lovettsville, VAN25392Walker Joseph E · Hoodsport, WAN255YWeeks Kermit A · Dolk City, FLN2639Neuman Allen D · Sanger, TXN26AGVintage Aero Inc · Brandon, FLN26AHOklahoma Warbird Aviation LLC · Oklahoma City, OKN282FCClassic Toy Barn LLC · Central Islip, NYN28690Fortin Russell J · Linden, MIN302Alaska Bush Leasing LLC · Anchorage, AKN306WAllen Cheryl L · Hilltop Lakes, TXN306YDaly Clifford T · Garden City, NYN3184MMorgan Richard D · Belton, TXN318YFreeman Heritage Collection LLC · Kingsbury, TXN31GLDanielle Michael G Trustee · Cottage Grove, ORN323CJKuhnert Michael C · Topping, VAN33176Hauck Dennis J · Crawfordsville, INN336ESamuilov Vladimir A · Sound Beach, NYN33QYanks Air Museum · Baldwin Park, CAN363AEEichhorn Adrian A · Mclean, VAN38992Johnson Bros Aviation LLC · Sweetwater, TXN390HKlubichek Janet C · Winnemucca, NVN39681Price Donald N · Houston, TXN40265American Airpower Heritage Flying Museum · Dallas, TXN4119AManning Philip J · Melbourne, FLN414UIronworks Air LLC · Rogers, MNN439EWImlay Ryan E · Livermore, CAN444MTriple 4 Mike LLC · Crystal Bay, NVN46199Hagerstown Aviation Museum Inc · Hagerstown, MDN46389Boggs Wayne G · Tampa, FLN464BCCaldwell Collection Inc · Oklahoma City, OKN46502Simply Living LLC · Fort Myers, FLN4652VBlanton David L · Valley Center, KSN46876American Airpower Heritage Flying Museum · Dallas, TXN46881Riffle Brian W · Auburn, WAN47015Mohr Charles F · Buffalo, NYRegistration revokedN47054Elrod Brent W · Cashion, OKN47117Bauer Aviation LLC · Reese, MIN47154Williamson Rolla Charles Jr · East Falmouth, MARegistration revokedN47158Jorgensen Jeremiah D · Elizabethtown, KY
Back to AD 52-03-01