AD 2007-07-11
Registered aircraft · 121
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:2007-07-11')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-07-11')
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:2007-07-11') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-07-11') 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.
N35PSSpotlight Capital LLC · Flower Mound, TXN35RFNational Aircraft Leasing LLC #2 · Seattle, WAN361RRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN366FBMbl Financial LLC · Highland, UTN384JKTravelconfirm Aerolease Inc · Portland, ORN403SLRegistered aircraftN409BMKsnl Aero LLC · Shawnee, OKN425JRTb Equico LLC · Beaumont, TXN42DH58dh LLC · Atlanta, GAN445STNp Aviation II LLC · Atlanta, GAN454THG200 Aviation LLC · Gentry, ARN468JJPdl Holdings Fl LLC · Tampa, FLN500AGCd 321 LLC · Cypress, TXN513RBBeasley Roger K · Austin, TXN513UBC Street Holdings LLC · Newport Beach, CAN573PTLoxodonta Aviation LLC · Vero Beach, FLN597NEFiwc26 LLC · El Paso, TXN597RBBaugh Aviation Services LLC · Orem, UTN5BCTsb Aviation Inc · Madera, CAN606HPMustang 99 LLC · Austin, TXN612FAGroup Project Eight LLC · Bountiful, UTN619KSBank Of Utah Trustee · Salt Lake City, UTN631DVCsc Delaware Trust Co Trustee · Wilmington, DEN65ERM G Investment Properties LLC · Van Nuys, CAN663SBKka Enterprises LLC · Flower Mound, TXN679MMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN67LRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN682RVKr Escapes LLC · Wilmington, DEN688HLH&L 168 LLC · Las Vegas, NVN699DB699db LLC · Vienna, VAN703MSHillpointe Aviation Fl LLC · Winter Park, FLN707MZAdams Aviation Services Inc Trustee · Wilmington, DEN707SQFreedom 200 LLC · Dallas, TXN710RHValiair Lc Trustee · Casper, WYN710TCCd 321 LLC · Austin, TXN716JWTango 280 Holdings LLC · Spring, TXN718CFMustang Equipment LLC · Dallas, TXN721CCN721 Cc LLC · Lewes, DEN723RHRadco Aviation LLC · Atlanta, GAN726DRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN748QSJkp Enterprises Inc · Gainesville, FLN751BCInternational Bank Of Commerce · Laredo, TXN765MMacys Corporate Services LLC · Springdale, OHN765MSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN765WMMcfly Air LLC · Downers Grove, ILN765WSMelex Rentals LLC · Delray Beach, FLN811WKKovo Holdings LLC · Sugar Land, TXN819VE60-206 LLC · Southlake, TXN856T4ds LLC · Blaine, MNN860CBGolden Time Management LLC · Ogden, UT
Back to AD 2007-07-11