AD 2000-25-52
Registered aircraft · 649
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-25-52')
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-25-52')
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-25-52') 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-25-52') 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.
N369NRegistered aircraftN-number assigned (import), not yet registeredN369NKButler Aviation Investments LLC · Tonopah, AZN369PBHelicopter Aviation Services & Leasing Inc · Miami, FLN369PDCity Of Atlanta · Atlanta, GAN369SCVertical Flight Path LLC · Wilmington, DEN369SDPyramid Property Development And Management LLC · Cedar Lake, INN369TAHva Inc · Summersville, WVN369TRChehalem Helicopters LLC · Newberg, ORN369TVTennessee Valley Authority · Muscle Shoals, ALN369WYReece Construction Company · Marysville, WAN369ZMRegistered aircraftN36FGCalifornia Department Of Fish & Wildlife · Sacramento, CAN36KRDragonfly Aviation LLC · Mirando City, TXN371PDCity Of Atlanta · Atlanta, GAN3766ZBanfield Patrick C · Frazier Park, CAN377LWPremier Helicopters LLC · Kalispell, MTN383FJ&J Holdings And Investments LLC · Phoenix, AZN387RFMid America Flight Museum · Mount Pleasant, TXN40090Bank Of Utah Trustee · Salt Lake City, UTN400MBPrecision Heli-Support LLC · Mesa, AZN4010RBank Of Utah Trustee · Salt Lake City, UTN40125N525gm LLC · Bozeman, MTN4037LSouthern Aircraft Consultancy Inc Trustee · Casper, WYN405ATRotor Blade LLC · Georgetown, SCN411AFTeryjon Aviation Inc · Bluefield, VAN411JHHeidrick Joe · Woodland, CAN411WJNorthwest 60 LLC · Kalispell, MTN415WCWilson Construction Co · Canby, ORN41776Warbirds-3 LLC · Kalispell, MTN41AJEnglish Air Service LLC · Georgetown, TXN420KTRegistered aircraftN420WCWilson Construction Company · Canby, ORN421KY250 Logistics LLC · Mount Pleasant, TXN421SPKentucky State Police · Frankfort, KYN421VSVertol Systems Company Inc · Destin, FLN424WCWilson Construction Co · Canby, ORN425WCWilson Construction Co Inc · Canby, ORN4265JRatcliff Dustin · Saltville, VAN4292DUrocopters Inc · Lancaster, CAN42FFBeef Aviation LLC · Bradenton, FLN4337BBatto John H · Carson City, NVN43BATerrell Bill · Port Orange, FLN445SAvitek Inc · Plymouth, MIN4467VWilson Robert B · Superior, AZN450AGInternational Air Services Inc Trustee · Carson City, NVN451HAIron Horse Aviation LLC · Marshalltown, IAN454JHJack Harter Helicopters Inc · Lihue, HIN457GMCentury Aviation Inc Trustee · Wilmington, DEN458HWHeliwild Investments LLC · Austin, TXN458PBBarbaro Paul G · Argyle, TX
Back to AD 2000-25-52