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.
N4341LCut And Snip Flyers LLC · South Weber, UTN4342LChenaille Lawrence A · Martinsville, INN4343CHarwood Mark D · Cossayuna, NYN4343LDiamond C Aviation LLC · Gentry, ARN4343UBurke Jonathan D · Gaylord, MIN4344BMckinnon Harvey T · Thompson Falls, MTN4344LTorbett William H Jr · Stockbridge, GAN4344UKelly John M · Gastonia, NCN4345UCaskey Martin K · Paso Robles, CAN4346CHill H Charles II · South Hero, VTN4347LChristiansen Steven P · Spokane, WAN4347UAland Raymond J · Saint Clairsville, OHN4348CRankin Kevin J · Maryville, MON43490Phillips Aviation LLC · Winnemucca, NVN4349BLee Robert E · Medford, WIFirst renewal noticeN4349CCollins Jeffrey L · Camilla, GAN4349UEmbry Riddle Aeronautical University · Prescott, AZN434CBYates David M · Haysi, VAN4351CKinkle Douglas C Trustee · Colusa, CAN4351EDetroit Lakes Aviation Inc · Detroit Lakes, MNN4351LWaggener James Franklin Jr · West Memphis, ARN4352Davis Jim F · Poteau, OKN4352CThor David L · Thompson Falls, MTN43538Laperle Brian D · Colebrook, NHN4353CKeran Gary R · Natchitoches, LAN4354CDavis Isaac J · Soldotna, AKN4355CHaynes William S · Chillicothe, TXN4357BBettis Frederick W · Crestview, FLN4357CWarren Mark A · Colorado City, CON4357ESmith William H · Moultrie, GAN4357USilcott Robert W III · Fairview, OKN4358BVaughn Thomas N · Shallowater, TXN4358FKown William B · Hamilton, ALN4358LMays John Anthony Sr · Cedar Hill, TXN4358UThomas Reginal D · Apison, TNN4359BAllen Bruce A · La Porte, INN4359LKoschara Nathaniel L · Geneseo, NYN435FSBaird Alan J · Naches, WAN4360EAnderson John E · Shell, WYN43614Cam Debra L · Eagle Point, ORN4361BFitts James A Jr · North Pole, AKN4361CBogan Jimmy III · Denison, TXN4361LFairbault Sky Club Inc · Waseca, MNN43624Clay Robert W · Princeton, MNN4362BHernden Michael R · Rockford, ILN4362EFloura David P · Blackduck, MNN4363CHusmann Mark D · Delta, CON4363PDe Santi Michael P · Fort Lupton, CON4364ELangley Aaron · Auburn, CAN4365BMorris Steven Jacob · Wasilla, AK
Back to AD 94-05-05 R1