AD 95-26-05 R1
Registered aircraft · 1,944
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:95-26-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:95-26-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:95-26-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:95-26-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.
N7183NTop 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, TXN7195HGregory Family Farms LLC · Lewes, DEN7195PSpitzer Helicopter LLC · Woodland Hills, CAN7196HState Of Alaska · Anchorage, AKN7196UThomas Aviation LLC · Orleans, CAN7197JBrown Ronnie J · Anahuac, TXN7197VExecutive Helicopters Inc · Myrtle Beach, SCN71AFDesert Air Ag Inc · Terreton, IDN71SEJax Transport LLC · Amarillo, TXN720CMCooper Mountain Ranch LLC · Snyder, TXN720HRHeather Rae LLC · East Greenwich, RIN720SMOlson Willow · Golovin, AKN721BBRs Aviation Services · Moorpark, CAN721JRDakma LLC · Parma, OHN722ATDevries Electric Inc · Pella, IAN722DLSky West Aviation Inc Trustee · Albuquerque, NMFirst renewal noticeN723MJ3 E LLC · Hudson, WIN723RGHatchett Creek Leasing Inc · Delta, ALN723VCVaught Air LLC · Crane, MON7244CMullinx Victor L · Holt, MON724HWheels In The Well LLC · Jonesboro, ARN724RGHeli Guide Leasing Inc · Crystal Beach, FLN725GTLambert Contracting LLC · Hollywood, ALN725SMS&M Aviation LLC · South Boston, VAN726WMichelesaire Inc · Wilmington, DEN727AKPsi Applications LLC · Cambridge, NEN727DTClassic Drywall LLC · Richmond, KYN727KPAero Leasing Inc · Brookings, ORN7282ABell Helicopters LLC · Melbourne, FLN728PGPolar Star Corp · Kalispell, MTN728TSSky King LLC · Baltimore, MDN729DBTtheil LLC · Saxonburg, PAN72HHPlane Fun Inc Tr Trustee · Snellville, GAN72PKJ&J Investment Of Puerto Rico LLC · Moca, PRN72WDZatzworks Inc · Homer, AK
Back to AD 95-26-05 R1