AD 46-39-01
Registered aircraft · 62
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-39-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-39-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-39-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-39-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.
N21164Christenson Dean A · Intl Falls, MNN21165Stewart Donald J · Charlotte, NCN21169Warren John P · White Lake, MIN21186Lea Richard M · Pasadena, MDN21195Williams John David · Omaha, NEN2131CJoyce Edward R · Jefferson, OHN22502Pennell Timothy M · Hickory, NCN22513Sutton Bradley V · Dallas, TXN22517Alseth Elif A · Rockton, ILN22531Coleman Burgess · S Lyon, MIN22543Rawson John · Orange, CAN22546Elliott Brandon J · Senoia, GAN22548V2 Aviation LLC · Mishawaka, INN22579Sutton Bradley V · Dallas, TXN23701Jackson Ramman S · Los Angeles, CAN23703Ackerman Jerry L · Spring, TXN23706Petersen Lewis C · Salisbury Center, NYN23710Klein John T · Austin, ARN23741Morris John B Jr · Kenai, AKN23784St Clair Joseph M · Wills Point, TXN23785Ackerman William L · Montgomery, TXN23792Swartz William L · Cumb Foreside, MEN26200Ulmer Clarence G · Aladdin, WYN26204Ton David B · Bremen, INN26219Ekin William A · Port Alsworth, AKN26223Park Derek B · Lyons, GAN26246Pederson William K · Hillsboro, ORN26249Patrick Ronald A · Louisville, KYN26265Rogers B L · Martinsburg, WVN26275Bresser Jason R R · Soldotna, AKN26279Dorris Terry E · Greenbrier, TNN26281Houghton Andrew P · Cypress, TXN26284Rupke Curtis · Winterville, NCN26285Stinson 10 LLC · Owosso, MIN26290Black Stephen L · Urbandale, IAN26295Mott William R · Beach Lake, PAN26409Frick Gary A Trustee · Marion, INN26419Blackwater Aviation LLC · Holt, FLN26439Warren John P · White Lake, MIN26441Historical Aircraft Squadron Inc · Carroll, OHN26448Reid David · Houston, TXN26449Ritenour John · Knoxville, TNN27708Wightman Randy A · Owosso, MIN27710Airpower Museum Inc · Ottumwa, IAN27732Shadwick Clarence R · Tunnel Hill, GAN27740California Antique Aircraft Museum · San Martin, CAN27757Davey Kenneth E · Lake Crystal, MNN27776Bauer Mark A · Palmer, AKN31504Gendron Matthew · Port Orange, FLN31507Hackenburg Jess P II · Montoursville, PA
Back to AD 46-39-01