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.
N595TSArner Michael D · Tolland, CTN595VNess David A · Minneapolis, MNN5960FBonventre Michael J · Greentown, PAN5960QPlett Leo V · Liberal, KSN5960SOlson Phillip F · Tenino, WAN5960WNewman Matthew T · Cedar Park, TXN5960ZMielke James W · Wasilla, AKN5962QNewell Robert T · Angel Fire, NMN5962USieber Eric P · Shelburne, VTN5962WMcmath Stephen S · Spokane Valley, WAN5962ZJet Mic LLC · Blossom, TXN5963QKatz Matthew · Los Angeles, CAN5963WPalm-Air Aviators LLC · Springville, UTN5963ZMcmahan Charles B · Gakona, AKN5964FDillard Gregory S · Columbus, MSN5964HRockdale Tiger Flight · Rockdale, TXN5964LHortman Walter J · Ivyland, PAN5964QLin Andrew Hsia · Huntingtown, MDN5964SMcnew John P · Brighton, CON5964UChandler Joseph R · Midlothian, TXN5965LRegistered aircraftN5965PPearce Ricky A · Parsons, KSN5965SOverstreet James C · Montgomery, TXN5965WHadfield Brant C · Kirkwood, MOFirst renewal noticeN5966FHalter George R 3rd · West Chester, PAN5966HStasiewicz John A · Milwaukee, WIN5966QFarwell Jason E · Lansing, KSN5967LRegistration Pending · Carolina, PRRegistration pendingN5967WZillah Heights Cherry Growers LLC · Zillah, WAN5967ZMitchell Thomas F · Freehold, NYN5968DGrand Lake Air Ventures LLC · Celina, OHN5968HSlaughter Don Wayne · Farmville, NCN5968QChess House LLC · Canton, SDN5968WDalken Dustin A · Fairhope, ALN5969DLynn John E · Fairborn, OHN5969QAbdelsalam Moustafa Gamal · Buena Park, CAN596DKShoup Douglas L · Ludington, MIN596NDSilverhawk Aviation Academy LLC · Caldwell, IDN596PHOtt Juston E · Newton, ALN596PSLester Thomas C · Anaheim, CAN596RVEagle Eye Aero LLC · Carencro, LAN596SGerondale Gerald G · League City, TXN596SCSpartan Education LLC · Tulsa, OKN5970BBlake Terry L · Saint Clair, MIN5970QYeager Robert Allen · Oregon City, ORN5970UThatcher Jay C · Helena, OHN5970WBlessing Randall L · Lebanon, PAN5971DHenderson Donald G · Bedford, INN5971LLetourneau University · Longview, TXN5971URegistered aircraft
Back to AD 90-04-06 R1