AD 94-05-05 R1
Registered aircraft · 26,232
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.
N66281Alaska Sky School LLC · Anchorage, AKN6628AJohnson Steve D · Oklahoma City, OKFirst renewal noticeN6628SN6628s LLC · Arlington, TXN6629NTimlin Jonathan T · Mc Alpin, FLN6629TSimpson Eric J · Salome, AZN662BDMetcalf Charles M · Thomaston, GAN662HRRaymond Thomas D · Somerset, TXN662SHRay Lonnie D · Murfreesboro, TNN6630SRoss Air Chicago LLC · Chicago, ILN66310Gieseke Joe R · Tuttle, OKN66314Tan Cfi LLC · Plano, TXN6631AUnternaehrer Robert U Trustee · Brunswick, MON6631EArmstrong Bruce · Port Orchard, WAN6631GRegistration Pending · Oak Creek, WIRegistration pendingN6631NBrushwood John W · Coshocton, OHN6631THaas David P · Bixby, OKN66322Barker Michael S · Stanford, KYN66329Nelco Farms Inc · Fairfield, IAN6632A3 Fly-N LLC · Carlisle, KYN66330Yon Joseph W Jr · Pendleton, SCN66332Landis Kurt M · Canyon, TXN66333Registration Pending · Cooksville, MDRegistration pendingN6633AKolp Mark H · Andrews, TXFirst renewal noticeN6633NVon Olnhausen James W · Billings, MTN6633SRegistered aircraftN66349Kecy Kevin · Owls Head, MEN6634AKallabis Harry · Camino, CAN6634EWinkles Ron M · Ardmore, OKN6634NSchelnick Charles M · Fredericksburg, TXFirst renewal noticeN6634TBensaida Said · Hawarden, IAN66356Noble Scott W · Fort Wayne, INN6635ALewis John · Abbyville, KSN6635FJenkins Keith · Corralitos, CAN6635SCoughanowr David D · Chatham, MAN66361Walker Joy S · Concord, GAN6636FChesterton Thomas W Jr · Watertown, MAN6636NDunn George E · Otis, MEN66376Backhaus John W · Hampton, NHN66379Curry Zachary A · Loveland, CON6637ASmedley Hank W · Lake Havasu City, AZN6637HToline Jeff A · Grand Chute, WIN66380Logan Thomas H · Canfield, OHN66383Tuskegee Airmen National Historical Museum · Detroit, MIN66384Anderson Rick L · Valley City, NDN66386Registration Pending · Portage, MERegistration pendingN6638AKeystone Cessna LLC · Melrose, FLN6638TSmolios Charles M · Nashville, TNN66393Dash Roger A · Niles, MIN66394Y&S Aviation LLC · Oceanside, CAN66395Murray Kevin D · Moneta, VA
Back to AD 94-05-05 R1