AD 2000-07-03
Registered aircraft · 557
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:2000-07-03')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-07-03')
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:2000-07-03') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-07-03') 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.
N695SDDerek Dunn LLC · Levelland, TXN69BKShimek Mark · Port Lavaca, TXN69NSAircraft Guaranty Corp Trustee · Oklahoma City, OKN6SGCedar Ridge Aviation LLC · Knox City, TXN6XWLewis Everett D · Comfort, TXFirst renewal noticeN6YSHawk Aircraft Sales & Leasing LLC · Sterling Heights, MIN7008NRobinson Helicopter Company Inc · Torrance, CAN7016GRocky Air LLC · Cheyenne, WYN7027UTtwn Media Networks LLC · New York, NYN702CCRpd Enterprises Inc · Nicholson, PAN702TFWhitfield Timothy D · Fairfield, NCN7030JTtwn Media Networks LLC · New York, NYN7037CTtwn Media Networks LLC · New York, NYN703JJJ J Helicopters Inc · Torrance, CAN7040VSilverhawk Aviation Academy LLC · Caldwell, IDN7046GHelo Operations LLC · Waynesville, MON7048CMn Helicopters Inc · Minneapolis, MNN7052VOut Front Cc LLC · Kalispell, MTN70583Bult Equipment LLC · Monee, ILN7078YJes Storage Co · Wyoming, ILN7086LN43926 LLC · Dandridge, TNN7089GB-Squared Helicopters LLC · Daphne, ALN7094JTtwn Media Networks LLC · New York, NYN7098NSearcy Moto-Air Inc · Searcy, ARN70KAEmerald City Aircraft Leasing Inc · Port Orchard, WAN7102ZRegistered aircraftN7114RUniversity Of Alaska Anchorage · Anchorage, AKN7119UTtwn Media Networks LLC · New York, NYN7133EAir Assault Agricultural Aviation LLC · New Castle, VAN7138CDe Aviation LLC · South Wayne, WIN715SGSilver Sky Helicopters LLC · Park City, UTN7162RPollux Aviation Ltd · Wasilla, AKN717PZThompson Helicopters LLC · Uvalde, TXN7183CState Of Alaska · Anchorage, AKN7183NTop Gun Precision Ag LLC · Skidmore, TXN7183PKerr Ken · Nome, AKN7183WConrad Charles J · Wasilla, AKN7184GEmerald City Aircraft Leasing Inc · Port Orchard, WAN7184NBas Part Sales LLC · Greeley, CON7187XSouth Florida Helicopters Inc · Indiantown, FLN71888Anjum Mohammad A · Melrose Park, ILN7188DUS Aviation Training Solutions Inc · Titusville, FLN7189ZSmd Vineyards Inc · Salinas, CAN718EPPeregrine Air LLC · Mount Vernon, WAN718SCHelico Rotors Inc · Miami Beach, FLN7192BAstroone LLC · Culpeper, VAN7192H7192h LLC · Redwood City, CAN7192URed Hawk Aviation LLC · Allegan, MIN7193YExcel Helicopters LLC · Orange Grove, TXN7195DCedar Ridge Aviation LLC · Knox City, TX
Back to AD 2000-07-03