AD 2002-08-03
Registered aircraft · 276
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:2002-08-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:2002-08-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:2002-08-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:2002-08-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.
N90BZMirand Alexander A · Huntington Beach, CAN91HBSale Reported · Hickory, NCSale reportedN920DPEnstrom Helicopter Corp · Menominee, MIN9238Cronite Global Corp · Parsippany, NJN9244Wahner Rudolf M Jr Trustee · Aston, PAN9266Olivers Helicopters Inc · Hampshire, ILN9274Just Right Solutions LLC · Negaunee, MIN9285November 9285 LLC · Higden, ARN93DASeptember Bravo Enterprises LLC · West Olive, MIN93GPHorizon Helicopters Inc · Newark, DEN942MACorderman Michael · Armstrong, IAN9552Runge Kerry A · Crystal Lake, ILN9563Marzich Frank M · Rockford, ILN9565Bailey Gordon J · Fayetteville, GAN9568Medic Choppers LLC · Springdale, ARN9573Styer David B · Pendleton, ORN9576Roznick John A · Stillwater, MNN9590Stone Heli LLC · Carrollton, GAN9591Freelance Enterprise LLC · Clayton, WAN9604Medic Choppers LLC · Springdale, ARN962SMWheels Flying Service LLC · Kalispell, MTN965CCannon Travis H II · Corinth, TXN976XMackechnie Martin J · Palm Harbor, FLN98FWHysell Donovan W · Atwater, OHN99YCStyer David B · Pendleton, ORN9GPGrangaard Orin T · Yerington, NVFirst renewal notice
Back to AD 2002-08-03