AD 94-05-05 R1
Registered aircraft · 26,230
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.
N99739Herzog Eric M · New Waverly, TXN9973AGuillebeau Instruction Inc · Sherwood, ARN9974YAnderson Jennifer DBA · Oroville, CAN99753Holliday Robert W · Tucson, AZN99757Walter Daniel E · Palmyra, PAN99761Delong Ronald D · Pueblo, CON9976AWestern Air Express LLC · Helena, ALN9976GAbernethy Joe H · Hickory, NCN9976YRogue Air LLC · Miller, SDN99773Goode Jeremiah M · Broadway, VAN9977AMielke Frederick J III · Plains, MTN99784Montgomery Robert L · Kingman, AZN99790Rush Francis N · Rayne, LAN997TSMcdowell John L · Wichita, KSN99808Godbold Joshua M · Perdido Beach, ALN9980AYork Robert L · Capitan, NMN99810Taschwer Jeffrey T · Mcfarland, WIN9981YCottrell Mark C · Leitchfield, KYN99828Hale Larry E · Granbury, TXN9983YDesplinter Glen · Bettendorf, IAN9984AWarwick Company LLC · Jupiter, FLN9984YAllen Chorman & Son Inc · Milton, DEN99853Aviation Museum Of Santa Paula · Santa Paula, CAN9986AHerbert Wallace R · Marble Falls, TXN9986YBillingsley Littleton C Jr · Spicewood, TXN99879N46p Inc · Fort Wayne, INN9987ALewis Benjamin · Delano, MNN9987YParker Steven Elliott · Bedminster, NJN9988YKw Air LLC · Darlington, INN99894Hard Alan N · North Aurora, ILFirst renewal noticeN99899Dicksion William D · Bremerton, WAN9989AHatcher Bradley M · Jackson, GAN998JMOveross James A · Independence, ORN998SCDrymon J Steve · Springfield, KYN99907Rentoumis Michael G · Altoona, FLN99913Gregory Vernon L · Swansea, SCN99919Poliak Mark A Trustee · Carmel, INN9991ASaunders James E · La Vista, NEN99924Harvell Randall W · Manteno, ILN99928Kinker Christopher C · Charlestown, INN99935Otto Dennis M · South Haven, MIN99936Abell Eric E · Centerville, OHN9994YSale Reported · Quincy, WASale reportedN99956Chase 13 LLC · Wilmington, DEN99960Barnes Lloyd L · Independence, ORN9998AWhite Fox LLC · Springdale, ARN999EZGardner Gerald O · Brownsburg, INN999JCCoffman Mark · Sanger, CAN999JTCdm Dirt LLC · Snowflake, AZN999RDSale Reported · Colorado Springs, COSale reported
Back to AD 94-05-05 R1