AD 72-03-03 R3
Registered aircraft · 17,027
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:72-03-03-R3')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
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:72-03-03-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') 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.
N60743Cowart Frederic D · Baytown, TXN60748Flawless Aviation LLC · Loxahatchee, FLN60749Frazier Brian D · Jackson, MSN6074RKray Timothy P · Lincoln, NEN60756Vanjara Obaid U · San Ramon, CAN60757Follman Aviation LLC · Waterport, NYN6075GTango Aviation Rentals LLC · Austin, TXN6075JLowrance Kathleen C · Plano, TXN6075RNelsn Hans A · Sergeant Bluff, IAN60761Code 1 Flight Training LLC · Canton, TXN60767Turnier Mikel W · Middletown, NYN60769Del Duca Frank J · Bethel, MEN6076GColbert Farms Inc · Davenport, WAN6076RAdvanced Targeting Solutions LLC · Perkasie, PAN60773Edwards Air LLC DBA · Raleigh, NCN6077RCultra Daniel L · Rochelle, ILN60781Two Birds One Bear LLC · Upper Arlington, OHN60787Kenses Daniel T · Stuart, FLN6078ROancea Traian · Oakdale, CAN60790Jenkins Berry E · Bell, FLN60793Registered aircraftN60796Lemanski Thomas A · Port Townsend, WAN60797Portland Metro Aviation & Flying Club · Portland, ORN60798Hjl Farm Inc · Dagmar, MTN6079JSmith Richard D II · Luthersville, GAN60800Edens Harald E · Socorro, NMN60802Smith Jay · San Andreas, CAN60808Foster William L · Waco, TXN6080JRidgewood Corp Inc · Orangeville, PAFirst renewal noticeN60818Bailey James C · Drummond Island, MIN6081RWatler John L · Brazil, INN60822Hawkinson Paul M · Grand Rapids, MNN60825Namtvedt Erik L · Wasilla, AKN60830Ace Aviation Seminars LLC · Armuchee, GAN60831Itm Aircraft LLC · North Charleston, SCN60832Pharmacures Inc · Catasauqua, PAN60835Jet & Rotor Aviation LLC · Sacramento, CAN60836Avz Aviation Of Tennessee Inc · Knoxville, TNN60837Howard James S · Arlington, TXN6083RHatle Arlen J · Meadow, SDFirst renewal noticeN60846Erickson Daniel W · Tomales, CAN6084JHatloy Mark · Drayton, NDN6084RKdb Flying LLC · Branchville, SCN60855Douglas Raymond M · Hamilton, NYN60860Joebravo Aviation LLC · Derby, KSN60861Hansen Aviation LLC · Savannah, GAN60865Breitberg Benjamin D · Ridgecrest, CAN60870Stracener Adam K · Pittsburg, TXN60875Registration Pending · Soldotna, AKRegistration pendingN60878Barnett Shawn N · Hartsfield, GA
Back to AD 72-03-03 R3