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.
N4022YKelley Kitty K · Albion, IDN4022ZKahn Steven H · Port Alsworth, AKN40230Harris Dan C · Rockford, TNN40234Mallow David N · Rio, WVN40238Blue Ridge Community College · Weyers Cave, VAN4023BSachs Robert W · Green Cove Springs, FLN4023FFreese Barry L · Leonardtown, MDN4023TSky Helicopters Inc · Desoto, TXN4023XRhodes Stephen · Marion, NCN4023YSky Helicopters Inc · Desoto, TXN4023ZLunenschloss Michael L · Anchor Point, AKN40246Harper Matthew C · Anchorage, AKN4024JKeleti Laurie · Lakewood, NJN4024XFaussett Thomas J · Greenville, MIN4024YJr Aviation LLC · Temple, TXN4024ZBrown Timathy S · Wasilla, AKN4025BPalmer James F · Walla Walla, WAN4026ECircle C Farms Inc · Bainbridge, GAN4026NSeiger T W DBA · Medford, ORN4026XAlderin Charles A · Center, NDN4026YOlsen Scott M · Forest Lake, MNN4027NC2c LLC · Chesterfield, MON4027PAg Air Squadron One LLC · Saint Joseph, ILN4027XMinor Joann M Raimond · San Diego, CAN40283Keech Mark A · Fairbanks, AKN40286Dwm55 LLC · Kalispell, MTN4028DDriebergen John A · Meridian, IDN4028EAmerican Airpower Museum · Farmingdale, NYN4028GUnited States Navy (Owner) · Millington, TNN4028WCmor Properties LLC · Saint Augustine, FLN4028ZFlower Pot Cattle Co LLC · Arlington, AZN40294Reese Steven A · Shoreline, WAN40297Chupp Titus · Clark, MON4029BDiebel Dean L · Orlando, FLN4029PAugustus Aircraft LLC · Whitefish, MTN402AArcher Aircraft LLC · Wilmington, DEN402AJ2lyons Enterprises LLC · Wellington, FLN402BDMartin Matthew J · Arlington, TXN402BFSnell Marion Lea · Ackerly, TXN402BKN402bk LLC · Nantucket, MAN402BLPiper Aircraft Inc · Vero Beach, FLN402CACivil Air Patrol · Maxwell Afb, ALN402CENorth American Aerial Surveys LLC · Tucson, AZN402CVCivil Air Patrol · Maxell Afb, ALN402CZEmission-Air Inc · Welcome, NCN402DJFlying Mermaid LLC · Aiea, HIN402DSDelaware State University · Dover, DEN402DZSamadi Jamshid · Leesburg, VAN402EASneed Leasing LLC · Nashville, TNN402ERLeighnor Aircraft LLC · Prescott, AZ
Back to AD 2007-04-19 R1