AD 2007-04-19 R1
Registered aircraft · 108,434
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-04-19-R1')
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-04-19-R1')
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-04-19-R1') 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-04-19-R1') 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.
N32056Steuer Christopher · Plumas Lake, CAN32059Coast Property Inc · Nipomo, CAN3205BDurben Robert W · Newcomerstown, OHN3205DWest James · Monroe, MIN3205FHawkins William J II · Saint Petersburg, FLN3205JSchumacher Eraine · Hague, NDN3205UBanducci Debra L Trustee · Bakersfield, CAN3205VGonzalez Efrain · Manhattan Beach, CAN32066Chadwick Cobb Kristy L · Tallahassee, FLN32067Legeros David · Brooklyn, NYN32068Christensen Gary L · Royal City, WAN32069Adb Investments LLC · Duncan, SCN3206DDenny Michelle L · Chugiak, AKN3206EMorey Airplane Company Inc · Middleton, WIN3206JHopman Pablo I · Stow, MAN3206LAlpha Tango LLC · Omaha, NEN3206MHme Aviation LLC · Mount Pleasant, SCN3206SHall David J · Red Bluff, CAN3206YN3206y Aviation LLC · Bloomfield Hills, MIN32070Williams Seth M · Jeanerette, LAFirst renewal noticeN3207EArmstrong Aviation LLC · New Orleans, LAN3207FGoodwin Winston L · Cypress, TXN3207LRdl Construction Inc · Hollister, CAN3207PTraverse Air Inc · Traverse City, MIN3207RLingerfelt Joseph A · Woodburn, ORN3207SSouthern Star Aviation LLC · El Campo, TXN3207UTaf Aerial Services LLC · Beeville, TXN3207WZero Seven Whiskey LLC · Norco, CAN320827550g LLC · Birmingham, MIN32089Vosberg Jeffrey A · Norwalk, IAN3208AKreitel Cody James · Anchorage, AKN3208SZirul James V · Kenai, AKN3208UDiller Larry K · Fairview, MIN3208YHamilton Triple C Farms · Ririe, IDFirst renewal noticeN32095Rogers Dekishon W B · Atlanta, GAN32097Seniram Air Inc · Wilmington, DEN32099Odland Steve E · Luverne, MNN3209DCirrus 1jr LLC · Webster, NYN3209JDennis John W · Mooresville, NCN3209PMg Renewal Corp Inc · Salt Lake City, UTFirst renewal noticeN320AGBusenbark Kenneth A · Niceville, FLN320AJDaedalus Wings Inc · Malvern, OHN320AKMclauchlin Todd · Sparks, NVN320AUAuburn University · Auburn, ALN320BFlorida Keys Aviation Service & Leasing LLC · Key Largo, FLN320BDDavis Burton D · Jefferson, IAN320BMSchenk Jonathan M · Amarillo, TXFirst renewal noticeN320BSPriewe Steve R · Sardis, MSN320BVLaird Brian N · Monument, CON320BWWinterberg Brian D · Garberville, CA
Back to AD 2007-04-19 R1