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.
N6303BUpper Valley Aero LLC · Hanover, NHN6305UMission Aviation Fellowship · Nampa, IDN6306CLongs Air Conditioning Inc · Avon Park, FLN6308HAmerican Aviation Inc · Page, AZN6314CC4p LLC · Jackson, TNFirst renewal noticeN6314DSaghafi Jamsheed Trustee · Parma, OHN6318BCenturion Associates 2 LLC · Elgin, SCN6320PSims Jacob Trustee · Montrose, CON6328CArnold Aviation & Thunder Mountain Express Inc · Cascade, IDN6328PSabath Kenneth J Trustee · Powell, WYN6328YKoehn Lacey · Van Horn, TXN6329CUnited Indian Mission DBA · Tucson, AZN6329YDiablo Aviation LLC · Pleasanton, CAN6330CLos Angeles County Sheriffs Department · Long Beach, CAN6339CBowles Donald E Jr · Dallas, TXN6342YFdxp Inc · High Point, NCN6344YCole William G · Garner, NCN6345ZAerial Transport LLC · Dover, DEN6352ZSale Reported · Anchorage, AKSale reportedN6355CDutch Air LLC · Kalispell, MTN6357XMaanum Scott R · Park Rapids, MNN6358SStancil Joseph E Jr · Eagle River, AKN6359BRoss Stout Architect Inc · Indian Wells, CAN6359WScarlett Cameron O · Madison, WIN6362AMillican Clifford A · Burleson, TXN6364BKgnf LLC · Grenada, MSN6364CSukhakarta Rentals LLC · Cedar Park, TXN6385PBada Alfredo · Mcallen, TXN6386CBas Part Sales LLC · Greeley, CON6388YMaclean Kenneth J · Northborough, MAN6389WSpenco Inc · Sale Creek, TNN6391UGimli Son LLC · Fort Lauderdale, FLN6392CTretter Nicholas · Holden, MAN6392ZFlorence Michael · Portsmouth, NHN6394DManzur Miguel Antonio · Mcallen, TXN6395ZN Berk Consultant Inc · Greenwich, CTN6397BLayson Walter E · Calhoun, GAN6397YAsher James A · Pasadena, CAN6398WPivac Jorge I · Chandler, AZN6398YSinglepoint Technologies Corp · Richmond, VAN6399KI B Development LLC · Monahans, TXN639FSC&Bh LLC · Vernal, UTN6402NManos Con Alas Aviation · Stateline, NVN6405XArctic Aviation Leasing LLC · Anchorage, AKN6408NBorders Nowell W · Edinburg, TXN6409WBreedlove Joe · Skiatook, OKN6409YChino Aviation Inc · Chino, CAN6410NAerial Services Inc · Cedar Falls, IAN6413PAlta Air LLC · Boise, IDN6416WGallien Anthony · Livermore, CA
Back to AD 2002-07-01