AD 46-49-01
Registered aircraft · 1,006
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-49-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-49-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-49-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-49-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.
N2434HBigham Dylan · Windsor, CAN2446HGregory Vernon L · Swansea, SCN2449HTracy Kevin A · Sequim, WAN2467HOmlid Robert L · Watford City, NDN2472HDunlap Lloyd A · Brighton, MIN2475HSchroer Jeffery B · Warrenton, MON2485HMcnutt Richard K · De Pere, WIN2500HNabb Andrew W · Mooresville, NCN2503HCarlson Lyle V · Allen, NEN2511HGalassi Thomas D · Petersburg, ILN2516HFolk George W · Martinsburg, WVN2523HShadd James A · Lancaster, OHN2525HWilliams Randy Hillman · Blue Ridge, GAN2536HGregory Vernon L · Swansea, SCN2537HMaddock Jay B · Sugar Grove, ILN2539HFortune Conversions Corp · Cave Creek, AZN2546HWing Wendall E · Marion, MIN2551HCoupe Groupe Inc · Bayport, NYN2555HJohns Leroy E · Keenesburg, CON2569HFolk George W · Martinsburg, WVN2576HMartin Aaron M · Penn Yan, NYN2586HDix Walter R Jr · Winter Haven, FLN2593HUpham Chester R III · Mineral Wells, TXN2596HLayne Keith R · Oklahoma City, OKN2597HQuantie Harold · Locust Grove, OKN2602HWilson Rutledge P III · Marietta, GAN2606HOlberding Timothy · Bolingbrook, ILN2608HGregory Vernon L · Swansea, SCN2627HGarman Karl E · Crystal Lake, ILN2633HGlenn Michael J · Payson, AZN2634HReaser Jordan Scott · Pacific Palisades, CAN2642HBennett Steven A · Boylston, MAN2650HBreza Thomas S · Laud By Sea, FLN2663HGregory Vernon L · Swansea, SCN2678HGlasser Gene P · Glen Ullin, NDN2679HAbrams David E · Boston, MAN2681HFrazier Jesse O · Barnwell, SCN2698HGoodrich James A · Jacksonville, MON26RRightfooted Foundation International · Tucson, AZN2700HBousquet Arthur David · Highgate Center, VTN2701HRegistration Pending · San Antonio, TXRegistration pendingN2702HHessling Gary G · Trinidad, CON2704HBoelke Ross D · Armada, MIN2714HRey Thomas A · Fort Worth, TXN2715HGregory Vernon L · Swansea, SCN271HRegistered aircraftN2727HQuada Andrew W · Lowell, MIN2730HGregory Vernon L · Swansea, SCN2735HMorris Robert L · Ulm, MTN2738HDieter Walter T · Salome, AZ
Back to AD 46-49-01