AD 2002-07-01
Registered aircraft · 3,466
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:2002-07-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01')
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:2002-07-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01') 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.
N6417NTaylor Michael Norman · Chino Hills, CAN6419BMarshall Timothy M Trustee · Tucson, AZN6419XPernat Frank J Trustee · Chaska, MNN641MRoyo Marco · Canutillo, TXN6420YFlying Amigos Aviation LLC · Las Cruces, NMN6421YHulett Gregory · Las Vegas, NVN6428ZDv Aviation Inc · Brainerd, MNN642DSJgm Aviation LLC · The Woodlands, TXN6431NMorton Craig Allister · Toluca Lake, CAN6431PHhd Aviation LLC · Hamilton, OHN6433XRand Carl · Durango, CON6434NDecker Rufus G III · Arlington, VAN6436BConway Jenna M · Camarillo, CAN6439NSpectraq LLC · Las Vegas, NVN643UFRegistered aircraftN-number assigned (import), not yet registeredN6440BWolfe Transportation Inc · Meridian, IDN6440YTamarack Graphics LLC · Salt Lake City, UTN6442YPouppeville LLC · Tulsa, OKN6443NEwers Richard G · Indio, CAN6444WBas Part Sales LLC · Greeley, CON6445YRomero Bernard L · Santa Fe, NMN6446WRichter Aviation Inc · Maxwell, CAN6447ACouch Andrew W · Newport Beach, CAN6447XSteller Air Service LLC · Homer, AKN6449HN6449h LLC · Pompano Beach, FLN644CTC323 Holdings LLC · La Grange, TXN644VCElder Daniel R · Kalispell, MTN6450YAttica Flyers Inc · Lafayette, INN6453NUgly Johns Aircraft LLC · Afton, OKN6455CPruett Steven H · Midland, TXN6457BJcb Holdings LLC · Helena, MTN6459CBallair LLC · Dalhart, TXN6460HWhitetail LLC · Anchorage, AKN6461ZJav Air Services LLC · Anchorage, AKN6466NHagan Joseph · Steward, ILN6469NKestrel Aviation LLC · La Center, WAN646CDRegistered aircraftN6470HJb Aircraft LLC · Anchorage, AKN6470YSkyhigh Enterprises LLC · Holland, MIN6476WWill Investments Inc · Englewood, CON6477HTurbines Ltd · West Point, NEN6479NSouth Aero LLC · Albuquerque, NMN6479YGv Air Inc · Medford, ORN647SBHyde Matthew L · Santa Cruz, CAN6482YSky West Aviation Inc Trustee · Albuquerque, NMN6484AState Of Illinois · Springfield, ILN6489WReed Michael · Temple, TXN6491BTerrill Guy J · Dillon, MTN6491HBlue Air 3 LLC · Miami, FLN6491ZAndolina Richard F Jr · Hornell, NY
Back to AD 2002-07-01