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.
N70810Wrangell Mountain Air Inc · Palmer, AKN70822Southern Seaplane Inc · Belle Chasse, LAN7103QLord Hill Aviation LLC · Snohomish, WAN710MHK Bay Air LLC · Homer, AKN710TDDuke Ray J · Oak Point, TXN711BGSaybrook Offshore LLC · Guilford, CTN711FBLing Scott P · Old Saybrook, CTN711HEDesert West Enterpises LLC · Roswell, NMN711JFTwin D LLC · Lake City, FLN711PJRender Chad · Pine Bluff, ARN711TMPeters James L Trustee · Brighton, MIN711TWMartens Ruth C · Wheaton, ILN712VTMiddle Fork Aviation Inc · Challis, IDN7138QArctic Aviation Leasing LLC · Anchorage, AKN713TGSelway Construction Group LLC · Moscow, IDN7144QJungle Breezes Youth Ministries · East Earl, PAN7154DChick Theodore D · Beulah, NDN7162DFaulkner Winthrop Sewell · Anchorage, AKN717DKRegistration Pending · North Las Vegas, NVRegistration pendingN717MRSt Johns Aviation Partners II · Beaumont, TXN718APAviation Trust Company LLC Trustee · Oklahoma City, OKN71900Savage David E · American Falls, IDN71924Keystone Aerial Surveys Inc · Philadelphia, PAN71967Lipan Creek Flying Service LLC · Eola, TXN71991Bush-Tell Inc · Aniak, AKN71994Skydive Buckeye LLC · Goodyear, AZN71ESBig Tex LLC · Reedsburg, WIN71MKWyeth Patrick · Chino Valley, AZN71MVVolatile Aero Ventures LLC · Boulder City, NVFirst renewal noticeN71PHPlh Air LLC · Post Falls, IDN71WTBear Cat Air LLC · Gun Barrel City, TXN72027Candy Corn LLC · Missoula, MTN72050Petty Line Const Co Inc · Clanton, ALN72094Gibertoni James E · Fairbanks, AKN720GEHoucke Pascal · Newtown, PAN721Department Of The Interior · Boise, IDN72106Dahl George Robert · Bethel, AKN72117Ott Steve G · Reedpoint, MTN7213NSouth Aero LLC · Albuquerque, NMN72160Mccauley Thomas I · Puyallup, WAN72194Skydive Ky LLC · Cecilia, KYN721NRUS Department Of The Interior · Boise, IDN72222Jouppi Kenneth J · Ward Cove, AKN7222NN B Tweet & Sons · Nome, AKN72285Cave Creek Organics LLC · Flagstaff, AZN72288Roberts Matthew R · Idaho Falls, IDFirst renewal noticeN722ELBristow Bryan M · Albany, ORN722PDW O Zangger And Son Inc · North Loup, NEN722RRAncira Autos LLC · San Antonio, TXN722SJJackson Stephen L · Belvidere, IL
Back to AD 2002-07-01