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.
N9890BSchoettmer Thomas C · Greensburg, INN9890JOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLN9891TDunkley Bret Y · Kotzebue, AKN9894BAscension Flyers Inc · Stillwater, MNN9894JKosko Stanley G · Seattle, WAN9896JVande Berg David M · Sioux Center, IAN9897BMccrorie LLC · Helena, MTN9898THumphress John A III · Campbellsville, KYN9899BSonic Inspection Corp · Edmond, OKN989CCPlanes & Things Inc · Collinsville, OKN989WTArmitage Alan J · Midland, MIN98BVUSA Air LLC · Ruskin, FLN98DTStubby Wings LLC · Eden Prairie, MNN98EJGerard Luke T · Johnson, KSN98JPWetstein James M · Anchorage, AKN98RBJones Mavin D · Monroe, UTN98SSSoutheastern Oklahoma State University · Durant, OKN98VJKistler Harvey S Trustee · Colby, KSN98ZEMichael Edwin Madison Aircraft LLC · Chattanooga, TNN99009Fennig Trevor L · Bryant, INN9900CHolt & Grooms Co Ltd · Carson City, NVN9900YGary E Gylten · Northwood, NDN9901CGritt Bradley · Marseilles, ILN99023May John D · Ward, ARN99039Alesso Casey H · Rosamond, CAN9903GCourtney Brooks Streetwise Inc · Avondale, AZFirst renewal noticeN99049Brown Jeffrey S · Jerome, IDN99050Berry Norman R · Knoxville, TNN99055Ag-Aero Services LLC · Spring Hill, FLN9905AHottois Scott A · Whittemore, MIN9906CCharbonnet Nicolas P · New Iberia, LAN9906GNielson Donald L · Independence, ORN99075Estuarial Medical Consultants · South Boston, VAN9907AHuff Steven D · Lake Havasu City, AZN99089Moore Michael W · Tacoma, WAN9908AKelly Larry E · Currie, NCN9908CBarker Geoffrey B · Plattsburgh, NYN9908GHarrison Jon Wittmeyer · Port Saint Lucie, FLN99092Mapes Joseph S · Stevens Point, WIN9909CChase Kenneth Charles Jr · Rochester, MNFirst renewal noticeN990BWBeachy Ronald · Kokomo, INN990CAJundi Adam · North Royalton, OHN990SUJeffryes Richard B · Creswell, ORFirst renewal noticeN99112Macario T Michael · Townsend, DEN99115Gregory Vernon L · Swansea, SCN99116Hallman Eugene A · Kasota, MNN99117Sanders John L · Sikeston, MON99119Carpenter William Edward · Mason, TNN9911ADaniels Bayce D · Anthony, NMN9911CSilva Brenda M · Snowflake, AZ
Back to AD 94-05-05 R1