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.
N76550Cebelak William G · Kent City, MIN76555Vancil Jon D · Collierville, TNN76558Parr William R Jr · Mason, TXN7655TMorrell Nathaniel A · Pelham, GAN7655USitta Donald C · Farmington, NMN7655XMedical Surgical Clinic LLC · Fort Scott, KSN76565Peterson Dean · Gothenburg, NEN76567Reavis Paul B · Gatesville, TXN7656MSparrowhawk Aviation · Manvel, TXFirst renewal noticeN7656XMiranda Maria J · Santa Maria, CAN76573Conrad Nicholas A · Midlothian, TXN76575Ibrahim George F · Redwood City, CAN76578Macdonald Thomas L · Laveen, AZN7657GDodd Brian G · Mount Vernon, SDN7657TGuarno Adam C · Milton, FLN7657XGordon Christopher R · Moose Pass, AKN76581Lee Marc T · Farmers Branch, TXN76585Anderson Thomas M · Fairbanks, AKN7658URegistration Pending · Oregon City, ORRegistration pendingN76591Dessertier · San Diego, CAN76596Jerome Jeffrey A · Conneaut Lake, PAN7659TKano Yoshio W · Barrington, ILN765LDBoisvert Robert R · Gardner, MAN76600Benda Carl III · Colorado Springs, CON76603Dunn Ward A · Columbia, SCN76608Widewings LLC · Alexandria, VAN7660XAdams John S · Roselle, ILN76611Peach Daniel J · Rockvale, TNN76613Hunter Joseph · Myrtle Beach, SCN76616Farnham Jesse J · Middlebury, CTN76617Martz Gary Rodney · Frederick, MDN76619Pitman Marvin L · Harrah, OKN7661MPaul Gregory A · Overland Park, KSN7661USweitzer Cameron D · Warrensburg, MON76621Couch John · Sunman, INN76624Missionair Inc · Danbury, CTN76625Brunner Thomas W · Manitowoc, WIFirst renewal noticeN76628Elhandt Bryan A · Missoula, MTN76629Liggett L Michael · El Dorado, KSN7662TTriana David · Goose Creek, SCN7662UMcintyre James C · Bethlehem, PAN76630Mosley Jessie W · Heber Springs, ARN76632Satanta Flying Service Inc · Satanta, KSN76633Burkey Richard A · Wagener, SCN76634Blunk Roger C · Wheatland, IAN76635Plane Air LLC · Paducah, KYN7663MRashid Shahn S · Clear, AKN7663TTc Flight LLC · Lincoln, NEN76644Call One Inc · Clarinda, IAN76645Mcleod Chad H · Sumter, SC
Back to AD 94-05-05 R1