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.
N55638Nimble Solutions Corp · Anchorage, AKN5563MJudkovitz Shmuel · Brooklyn, NYN5563QFishero John D · Spring, TXN5563UBlair James S · Beltsville, MDN5563ZTeterboro School Of Aeronautics Inc · Virginia Beach, VAN55640Adams Charles G III · Tawas City, MIN55641Gizzy LLC · Fish Creek, WIN55646Bluto Paul · Branson, MON55648Pic Aviation Inc · Bloomsburg, PAN5564FVazquez Oscar C · Moreno Valley, CAN5564UGoldinger Matthew L · Ligonier, PAN55652A Group Inc · Houston, TXN55656Denovellis Dennis T · Sidney, NEN55659Beiderman Allan R · Melbourne, FLN5565FHenley Brett · Manchester, TNN5565PGrant Zachary J · Indianapolis, INN5565UFiebich Stephan C · Kearney, MON55660Cifuentes Julio · Naples, FLN55667Stanick Paul J · Whitinsville, MAN5566UKingsbury Janet L · Miramar, FLN5566WRegistered aircraftN5566ZAlex Lawrence P · Loves Park, ILN55671Brown Christopher A · Tigard, ORN55673Smith Gordon H · Racine, WIN55675Sykes Kinsley · Palm Coast, FLN55677Arrow II Aviation LLC · Rocky Mount, NCN55678Murdick Robert A II · Bluemont, VAN5567MAnderson Layne A · Wichita Falls, TXN5567QRicol Aviation LLC · Naples, FLN5567W3k Weavers Investment Group LLC · Shelbyville, KYN55680Madsen Pest Management LLC · Siren, WIN55687Rieber Russell C · Stockton, CAN5568PSimon Jack · Spring Hill, TNN5568QJ & F Aviation Adventure LLC · North Fort Myers, FLN5568WRegistration Pending · Lebanon, INRegistration pending, pending cancellationN55691Brown Alan · Lugoff, SCN55695Straight Arrow Aviation LLC · Aurora, ILN55696Walla Walla University · College Place, WAN55699Hill Caleb · Indianapolis, INN5569MWichita Flight Training LLC · Wichita, KSN5569QBrian C Elbert · Rochester, NHN5569UJapikse Bert · Pawleys Island, SCN5569WBridges Michael D · Clovis, NMN5569ZLevandowski Joseph · Hamburg, NYN556BKd Helicopters Inc · Shingleton, MIN556FLKarg Asset Management LLC · Pocahontas, ARN556JRSemmig Jeffrey C · Oceanside, CAN556KRWhitaker Robert M · Richfield, UTN556MKurdzel Mark A · Chattanooga, TNN556MKPickering Gordon D · La Pine, OR
Back to AD 90-04-06 R1