AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.
N580MStockman Harold O · Elko, NVN580NDChristiansen Aviation LLC · Wilmington, DEN580SKEary Enterprises LLC · Peoria, AZN580SUMetro Aviation Inc · Shreveport, LAN580UBoard Of Regents Of The University Of Oklahoma · Norman, OKN58105Mooney Skies Unlimited LLC · Merritt Island, FLN5810HInternational Air Services Inc Trustee · Carson City, NVN5810USmith Herbert E · Rochelle, ILN5810VTuskegee Airmen National Historical Museum · Detroit, MIN58115Morten Jesse L · Larimore, NDN5811EMoss Jessee C · Ardmore, OKN5811QElliott Areospace LLC · Kalispell, MTN58120Air Giblinski LLC · Sedgwick, KSN58124North-Air Helicopters Inc · Frankfort, NYN5812LLindly Lowell J · Nashville, ARN5812USeymour Lori L · Woodstock, GAN5813HLoewen Walter · Kodiak, AKN5813QWalmsley Stephen R Jr · Menifee, CAN5813UStackhouse Thomas G · Bethlehem, PAN5813VRose William A · Chesapeake, VAN5813WStothers Brian · Lake Havasu City, AZN5813ZSmith Gregory E · White Lake, MIN5814DMessinger Donald C · Wasilla, AKN5814HPapich William · Boston, NYN5814UAnderson Timothy B · Cold Spring, KYN5814WP&K Enterprises LLC · Madison Heights, VAN58153Marsan Steve R · Sisters, ORN58159Mcclure Jeffrey S · Loomis, CAN5815HZernechel Craig A · Rockford, ILN5815LFidler Richard · San Francisco, CAN5815SClear Aire LLC · Las Vegas, NVN5815UMiller William W Jr · Henderson, NVN5815VDebs Raymond E · Boise, IDN58160Brb Flight Services LLC · Laguna Beach, CAN58162Link Stanley C · Theodosia, MON5816DTurner Robert E · Talladega, ALN5816LSparrowhawk Aviation LLC · Moraine, OHFirst renewal noticeN5816QHigh Flying Vision LLC · Clarksdale, MSN5816UHarsimran Singh · Las Vegas, NVN5816ZPerdew Paul T · Mcfarland, WIN58174Castle Farms Inc · Sunnyside, WAN5817FWicker John E · Lexington, NCN5817HPiper Aviation Museum Foundation · Lock Haven, PAN5817TSnow Robert I · New Caney, TXN5817WDow Jeff W · Port Hadlock, WAN5817ZLamb Matthew P · Edmond, OKN5818HSlatter Lowell J · Buhl, IDN5819DMiceli Michael J · Frewsburg, NYN5819HGaniere Constance L · Kemp, TXFirst renewal noticeN5819LLandauer Jacob · Gainesville, FL
Back to AD 90-04-06 R1