AD 94-05-05 R1
Registered aircraft · 26,231
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:94-05-05-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
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:94-05-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1') 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.
N32996Blythe Joseph L · Rockwall, TXN3299JEdwards Wallace · Commerce, MIN3299VChannel City Flyers Inc · Goleta, CAN329FKJackson Franklin · Martin, SDN329JGHernandez Jesus · Mchenry, ILN329VFFaller Vienna M · Port Orange, FLN32DPCarrell Samuel R · Knoxville, TNN32DTThomas Dennis K Trustee · Little Rock, ARN32VXVanmeter-Smith Racing · Wichita, KSN32WDDoherty David W · O Fallon, MOFirst renewal noticeN32WLAtkinson Karl A · Athol, IDN3300JIngram Jay Wallis · El Paso, TXN33010Thomson Kathryn Personal Representative · Lake Tapps, WAN33011Schutze Eric D · Ojai, CAN3301VErhard Robert T · Granville, OHN33023Jedlowski John R · Beaver Dam, WIN33029Taylor William L · Fairview, ORN3302JWignot Andrew R · Oceanside, CAN3303JWilliams Charles S · Pearland, TXN33044Smith Peter R Trustee · Lewistown, MTN3304KTomerlin Erin G · Napa, CAN3306JRound Engine Aero · Nashville, MIN3307KArbeau Denis M · Napa, CAN33087Swanson Timothy James · Bannister, MIN330BMoultroup Luke A · Richmond, VTN33112Mason Peter Trustee · Santa Paula, CAN3312JAlternate Air Inc · Seattle, WAN3312KGass William D Trustee · Mountain View, CAN3313JEsckelson Eric S · Cass City, MIN3313KMckenney Bret K · Billings, MTN3313VAviation Enterprises Inc · Springfield, MON3314HFortune Conversions Corp · Cave Creek, AZN3314KBartholomew Don · Gardnerville, NVN3314VCurtiss Steve L · Fortine, MTN3315JFlying Shiba Inus LLC · Dallas, TXN3315KBauerle Gerald F · Hammond, LAN33160Husnik Brad M · Forest Lake, MNN3316JChipollini Jorge · Springdale, ARN3318KMace Wade L · Ottawa, KSN331JCCsp Aviation Holdings LLC · Dallas, TXN331JMPetersen Christopher · Windsor, CTN3320JPollman Justin A · Sherwood, NDN3320KZema Monte L · Colville, WAN3321JFulton Ricky L · Alex, OKN3321KReiff Christopher R · Mansfield, MAN3321VRegistered aircraftN3322EBudd Sharon · Rushville, NEN3323JRichards Amy L · Union City, INN3323KBurrous Peter M · Mount Pleasant, SCN33253Yellowbird J-3 LLC · Manchester, WA
Back to AD 94-05-05 R1