AD 90-06-13
Registered aircraft · 1,827
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-06-13')
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-06-13')
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-06-13') 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-06-13') 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.
N551GFJ M Malone & Son Inc · Carlisle, ARN551HHGem Air LLC · Bakersfield, CAN551JKJk Aircraft Options LLC · Aripeka, FLN551JLN551jl LLC · Greenville, SCN551KAKajapa Air Inc · Vienna, WVN551LSMixed Wing LLC · Wilmington, DEN551MLBravo N551ml LLC · Irvine, CAN551MWHotzler Terry A · Windom, MNN551NCNion LLC · New Century, KSN551SJFav Tailwind LLC · Arroyo Grande, CAN551TGLake Vista Aeronautics LLC · Lewes, DEN551THInab LLC · Portland, ORN551TKTkl Equipment LLC · Owasso, OKN551WLPepin Enterprises LLC · Lewes, DEN551ZD501zd LLC · Palm Coast, FLN552BGRegistration Pending · Suffolk, VARegistration pendingN552CGCsc Delaware Trust Co Trustee · Wilmington, DEN552CJWolf Pack 7 LLC · Wilmington, DEN552CNRer Plane LLC · San Antonio, TXN553MJRat Pack LLC · Panama City, FLN554CGCoulson Aviation (USA) Inc · Portland, ORN554GRTvpx Ars Inc Trustee · North Salt Lake, UTN554TT & T Enterprises LLC · Santa Clara, CAN554TSS & S Seeds Inc · Carpinteria, CAN554VPJl Diversified LLC · Scottsdale, AZN555DSWeather Modification LLC · Fargo, NDN555EHHolen Endre · Las Vegas, NVN555FWCommerce Flight LLC · Commerce, TXN555HMAirops II LLC · Salinas, CAN555KTKilo Tango LLC · Birmingham, ALN555PGWagner Air LLC · Kendalia, TXN555RTSct Aviation LLC · Fort Lauderdale, FLN555WLGolf Air Inc · Bloomfield Hills, MIN556BGCitation Investments LLC · Dallas, TXN556MWN970aj LLC · Evans, CON557CSRabbit Hill Industries Inc · Bedford, NYN557MMUvalde Land Company LLC · Valdosta, GAN557MRMrjl LLC · Wilmington, DEN557PGCo Fire Aviation Leasing Inc · Fort Morgan, CON558CGCsc Delaware Trust Co Trustee · Wilmington, DEN558WWWestwood Property Management Inc · Aurora, ORN559BMCrockett & Koehler Lc · Layton, UTN559SFSd Aviation LLC · Aberdeen, SDN559WJWanger Jones Helsley Pc · Fresno, CAN55BHTop Flight LLC · Gilbert, WVN55EAShamrock Aviation LLC · Greensboro, NCN55LXWoodbine Aviation LLC · Lewes, DEN55MWCitation 560 LLC · Oshkosh, WIN55SRGrant Aviation Inc · Anchorage, AKN55WLLatshaw Sonja M · Vero Beach, FL
Back to AD 90-06-13