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.
N7052State Of Alaska · Anchorage, AKN7052DMundell Lola Trustee · Rosston, OKN7052FStephens Racquel C · Laguna Niguel, CAN7052GG&H Aviation · Louisville, KYN7052QHoloman T Michael · New Smyrna Beach, FLN7052RSell Carl N · Spanaway, WAN7052WPuskala Thomas S · Iron River, MIN7053Jsrs Holdings LLC · Las Cruces, NMN7053BStevens Alan · Meridian, IDN7053GSpare Change Enterprises LLC · Atlantic, IAN7053KMatlad Inc · Wilmington, DEN7053LVelvick Kathleen R · Peoria, AZN7053QCabrie Aviation Inc · Charlotte, NCN7053WRed Rock Flying School LLC · Mesa, AZN7054State Of Alaska · Anchorage, AKN70541Cl Finney Aviation LLC · Benton, KSN70549Andersen Mark · Huntley, ILN7054BWinter Jerry L · Cumming, GAN7054GSands Aviation LLC · Talking Rock, GAN7054KPehoski Joseph R · Anchorage, AKN7054WLanguage Gert Johannes · Hays, KSN7054YNordman Clay L · Catheys Valley, CAN7055State Of Alaska · Anchorage, AKN70555Hecht Waldo E · Vassar, MIN7055QSeagraves Brad J · Rockwell, NCN7055RRegistered aircraftN7055WRickard Donald L · Rowland Hts, CAN7056State Of Alaska · Anchorage, AKN70562Jets To Helis LLC DBA · Chandler, AZN7056QFleeman Joseph R · Lawrenceburg, TNN7056WEustace Daryl R · Scottsboro, ALN7057LTri County Rentals And Sales Inc · Chiefland, FLN7057QMindy Limited LLC · Muscatine, IAN7057RContreras Robert G · Norman, OKN7057WWatkins Travis · Haughton, LAN7058GDc Aerial Photos Inc · Fredericksburg, VAN7058JStaggs Jerry A · Weatherford, TXN7058KGiarusso Richard John · Carlisle, IAN7058RMoss Harold E II · Overland, MON7058WRoman Donald M Jr · New Middletown, OHN7059State Of Alaska Department Of Public Safety · Anchorage, AKN70597Rodriguez Hulises · Chula Vista, CAN7059DSmith Andrew W · Willow, AKN7059GFrank Todd E · Corsicana, TXN7059HFly In Helicopters LLC · Florence, SCN7059PProx Jonathan P · Enterprise, ALN7059SParker Helicopter LLC · Watsonville, CAN7059WMartin Gerard A · Boston, KYN7059YPhill-Air Inc · Dover, DEN705ABHart Aviation LLC · Emory, TX
Back to AD 90-04-06 R1