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.
N3977USale Reported · Pineville, KYSale reportedN39781Van Buren Nathaniel O · Anchorage, AKN3978SRowlett Charles · Fallbrook, CAN3979FAppleby Jack E · Atwood, ILN3979LLine Steven J · Jonesboro, ARN3979VWright Steven A · Odessa, FLN397JTelkamp Gary O · Rapid City, SDN3980JMushrush Kim · Tarrytown, GAN3980SThompson Richard L · Friday Harbor, WAN3980VRegistered aircraftN3981JKruger Gerhard B · Lathrop, CAN3981VConstantine Lucas · Anchorage, AKN3982PBlack Industries LLC · Helena, MTN3982USale Reported · Clearfield, UTSale reportedN3983FParr Ronald C · Ogden, UTN3983JVoizin Thomas J · Toney, ALN3983VInman Dentis Ray · Whiteville, TNN3984FBalbaugh Donald E · Cheboygan, MIN3984JMatta Figueroa Eduardo · Chapman, KSN3984SGreeson Gary D · Winchester, TNN3984USchram Claire · Roselle, ILRegistration revokedN3984VRussell Steve · Harper, ORN3985HReese Jon O · Wichita Falls, TXN3985JS & S Aviation LLC · Roanoke, INN3986FQuirk Charles L · Lake Charles, LAN3987FDe Young Darryl R · Okeechobee, FLN3987JRegistration Pending · Wylie, TXRegistration pending, pending cancellationN3987UPrice Nathan J · Crawfordsville, INN3988JTorrini Donald G · Edwardsville, ILN3988LWind Walker LLC · Tucson, AZN3988UJens Plane LLC · Marshall, VAN3988VPelotte Matthew J · Waterville, MEN3989BEgmond Aircraft LLC · Lewes, DEN3989HAllen Arlan R · Phoenix, AZN3989LCivico Royce S · Arlington, WAN3989SPaul Kassel Corp · Poway, CAN3989VFelten William J · Sagle, IDN3990EBrudjar Mike V · Vilonia, ARN39916Colby Clayton L · Kalispell, MTN3991SSoaring Comets LLC · Camarillo, CAN3991UWhite Earl L · Ridgeland, SCN3992HHaynes Roger M · Fremont, OHN3992JSabin Ronny L · Kennewick, WAN3992LAnderson Curt W · Independence, ORN3992SZero Dark Thirty LLC · Winder, GAN3992VBerryman Adna M · Houston, TXRegistration revokedN3993FMckee Robert D · Odessa, WAN3993JWegner Eric E Trustee · Oconomowoc, WIN3993URausch Nickalous R · Gettysburg, SDN3993VCushman Nicholas R · Mesa, AZ
Back to AD 94-05-05 R1