AD 46-40-01
Registered aircraft · 188
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:46-40-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:46-40-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:46-40-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:46-40-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.
N19128Golden Age Air Museum · Bethel, PAFirst renewal noticeN19129Rhinebeck Aerodrome Museum · Rhinebeck, NYN19139Mid Atlantic Air Museum · Reading, PAN19140Smith Happy · Rogersville, TNN19146Eastern Stearman Inc Trustee · Leesburg, VAN19149Euroaviation Inc Trustee · KematenN19164Malene John E · Cuyahoga Falls, OHFirst renewal noticeN19173American Aviation II LLC · Peyton, CON19177Lancaster Mark S · Ottumwa, IAN19178Stuckle Eugene A · Davenport, WAN19180Doyle Mary · Hampton, IAN19182Gonzales Donald M · Columbia Station, OHN19184Gonzales Donald M · Columbia Station, OHN19189Pavoni Justin F · Flemingsburg, KYN20615Kretsinger Steven H Trustee · Eugene, ORN20619Smith Happy E · Rogersville, TNN20624Fulton Gordon D · Mackay, IDFirst renewal noticeN20628Lipsett Rory · Lancaster, PAN20629Reid Michael J · Fort Towson, OKN20631Levine James David · Mentor, OHN20632Hagerstown Aviation Museum Inc · Hagerstown, MDN20641Gonzales Donald M · Columbia Station, OHN2088Mesmer Robert F · Grand Island, NYN22032Sharpe Rusty C · Murchison, TXN22036Miller David J · Fernandina Beach, FLN22047Harris Jeremy B · Boring, ORN224DBBongiovanni Joseph T · Ocala, FLN2302Schmidt Aaron B · Auburn, ALN232EThomson Scott R · Street SomersetN23EWestern Antique Aeroplane & Automobile Museum · Hood River, ORN244GAChristman Timothy A · Dayton, OHN24FAWullner Leeroy J · Cedar Rapids, IAN24FMCoon Robert E · Warrenville, ILN25183Smith Happy E · Rogersville, TNN25185Bruggeman Steven S · Shoreview, MNFirst renewal noticeN25323Zechini Marcus Kenneth · White Post, VAN25327Neal Sean Edward · Freehold, NYN25329Hargreaves William A · Lovettsville, VAN25392Walker Joseph E · Hoodsport, WAN2639Neuman Allen D · Sanger, TXN282FCClassic Toy Barn LLC · Central Islip, NYN28517Port Townsend Aero Museum · Port Townsend, WAN28521Carey Richard L · Hagerstown, INN28522Lowe Anthony E · Edina, MNN28525Barrett Brian W · Bellevue, WAN28533Shelly Mark P · Buckley, WAN28636Natoli Nathaniel T · Rutland, VTN28640Bormuth Alan R · Morganton, NCN28642Van Buren Karen A · Mchenry, ILN28644Mustang Holdings LLC · Omaha, NE
Back to AD 46-40-01