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.
N8309VSunde Bradley J · Fergus Falls, MNN8309YHolman Michael J · Anchorage, AKN830ADb-Gbr LLC · Sarasota, FLN830ADHaberling Hermann H P · Santa Teresa, NMN830BMurphys Auto Gyro Sales LLC · Dade City, FLN830BSShortt Aircraft Leasing LLC · Wilmington, DEN830LMKq Aviation LLC · Old Town, FLN830MAFlying Technologies LLC · Wilmington, DEN830MDMcelwee Glenda A · Lake City, FLN830PColeman Nathan R · Zephyrhills, FLN830PCSprowl Brian M · Millville, NJN830RCMartin Douglas J · Lutz, FLN830TNPrianti Paul J · Rockaway, NYN830UPixton Christopher T · Oregon City, ORN830ZCartwright John P · Watkinsville, GAN8310WBennett Anthony W · Bradenton, FLN83113N83113 LLC · Liberty, NCN8311FGregoire Brandon James Ernst · Orlando, FLN8311LSimpson Robert B · South Pasadena, CAN8311WAlford Charles Mikael · Meadow Valley, CAN8311YAj Air LLC · Cape Girardeau, MON8312HAlameda Aero Club · Alameda, CAN8312PPerson Timothy Ivan · Lake Stevens, WAN8312TRobinson Helicopter Co · Torrance, CAN8312VPester Mark C · Crookston, MNN8312WGillen James A · Cornville, AZN83130Registered aircraftN8313EShevah Avi · New Milford, CTN8313VMedlin Wayne D · Marshville, NCN8313WLummus Brett D · Forney, TXN8313YUnusual Attitudes LLC · Bates City, MON8314MDavid Ari C Esq Trustee · San Diego, CAN8314WWingsleasing LLC · Wichita, KSN8315MBurcin Michael H · Washington, PAN8315RJnl Aviation LLC · Orlando, FLN8315VReynolds Eric F · Princeton, MNN8315WJg Aero LLC · Smyrna, DEN8315YGolden Compass Aviation LLC · Wilmington, DEN8316CUplands Aviation Management LLC · Mineral Point, WIN8316DMarinephoto Helicopter LLC · Rehoboth Beach, DEN8316EJustfly Inc · Houston, TXN8316LCorletto Carlos · Bermuda Dunes, CAN8316NN8316n LLC · Rehoboth Beach, DEN8316RDelagrange Nathan A · Hicksville, OHN8316STeague Philip · Rattan, OKN8316YSchubnell Ryan A · Avondale Estates, GAN83177Nobles Joshua L · Tacoma, WAN8317GEagle Simulator LLC · Lake Oswego, ORN8317LWalker Paul R · Ursa, ILN8317RGross Roger S · Missouri City, TX
Back to AD 90-04-06 R1