AD 43-07-01
Registered aircraft · 174
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:43-07-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:43-07-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:43-07-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:43-07-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.
N48144Farley 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, TXN49481Fleeman 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, TXN51625Olten 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, TXN52479Chase Michael A · Humboldt, TNN52567Cadet Air Corp Museum · Tarkio, MON526PTKyler Chris K · Meridian, MSN52860Morton John C · Brewster, NYN52913Brown Charles T · Jackson, GAN53019Pflegl Henry A · Oregon City, ORN53279Leverich James E · Pampa, TXN53288Razorback Eaa 1388 · Pine Bluff, ARN53656American Airpower Heritage Flying Museum · Dallas, TXN53660Moon Brittany Lozier · Noblesville, INN53727Oaks Randall K · Oxnard, CAN53848Chumbley Eric M · Alvaton, KYN53929Wynecoop Shawn R · Bowbells, NDN53953Wilson Tommy · Greenleaf, IDN54201Casa Acquisitions LLC · Winter Haven, FLN54254Craig Robert A · West Chester, PA
Back to AD 43-07-01