AD 48-45-01
Registered aircraft · 219
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:48-45-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:48-45-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:48-45-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:48-45-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.
N4732GAmerican Airpower Heritage Flying Mu · Dallas, TXN47397Discoe Alexander · Kingsburg, CARegistration revokedN47439Welch Raymond · Elgin, ILRegistration revokedN47747Walk Michael J · Englewood, FLN47803Yanks Air Museum · Baldwin Park, CAN47922Nelson Flying Service Inc · Sidney, NEN47986Daniel Hardy L Jr · Derby, KSN48047Daniel Hardy L Jr · Derby, KSN48144Farley Sarah A · Rice, TXN48154Sale Reported · Redlands, CASale reportedN48328Mojo Aerospace LLC · Wilmington, DEN48488Busha James P · Oshkosh, WIN48671Acme Flyers LLC · Austin, TXN48705Chi Aerospace Inc · Portsmouth, NHN48841Riffle George W · Auburn, WAN49071Hawaii Warbirds Inc · Honolulu, HIN49232Casa Acquisitions LLC · Winter Haven, FLN49238American Airpower Heritage Flying Museum · Dallas, TXN49462Mertesdorf John P · Nicollet, MNN49481Fleeman Joseph R · Lawrenceburg, TNFirst renewal noticeN49795Hammond James F · Yellow Springs, OHN49797American Airpower Heritage Flying Museum · Dallas, TXN49830Mitchard John J · Sherrills Ford, NCN50024Mid Atlantic Air Museum Inc · Reading, PAN50175Obowa Denis J · Fergus Falls, MNN50341Hooey Kevin M · Corning, NYN50420Cutigni David L · Spencerville, INN50426American Airpower Heritage Flying Museum · Dallas, TXN50429Aircraft Registration Inc Trustee · KematenN50481American Airpower Heritage Flying Museum Inc · Dallas, TXN50809Dudley Denise M · Santa Margarita, CAN51090Butler County Warbirds Inc · Middletown, OHN51173American Airpower Heritage Flying Museum · Dallas, TXN51263American Airpower Heritage Flying Museum · Dallas, TXN51296Reigle Aviation South LLC · Orlando, FLN51625Olten Elmer Jr · Wright City, MORevoked, canceledN51628Manning Philip J · Melbourne, FLN51690Laurito Patsy · Pittsburgh, PARevoked, canceledN51874Patchett James J · Chapmansboro, TNN51939National Museum Of World War II Aviation · Colorado Springs, CON519SHAmerican Airpower Heritage Flying Museum Inc · Dallas, TXN52079American Airpower Heritage Flying Museum · Dallas, TXN52159Spence Justin A · Memphis, TNN5215ZAmerican Airpower Heritage Flying Museum · Dallas, TXN52224Kuhn Kathleen A · Williamson, NYN52479Chase Michael A · Humboldt, TNN52567Cadet Air Corp Museum · Tarkio, MON526PTKyler Chris K · Meridian, MSN52860Morton John C · Brewster, NYN52913Brown Charles T · Jackson, GA
Back to AD 48-45-01