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.
N403WBNew England Airlines Inc · Westerly, RIN403WDThomas Spencer S · New Castle, CON403WRRumburg William J · Gold Hill, NCN403XCc Motors LLC · Redding, CAN403ZAlpha Tango Aircraft LLC · Wilmington, DEN4040Parker Helicopter LLC · Watsonville, CAN4040EWildman Air LLC · Mckinney, TXN4040ZAcme Cub Training Inc · Anchorage, AKN4041EBurns Charles R · Huntsville, ALN4041FPine Bottom Aviation Services LLC · Martinsburg, PAN4041SDuplantis Nolan W II · Saint Martinville, LAN4042ARogden Aviation Inc · San Rafael, CAN4042QCharter Air Transportation LLC · Wayne, PAN40439Usoarflorida LLC · Fort Myers, FLN4043AByard Jeffrey G · Carson City, NVN4043BCrown Point Helicopter LLC · Morton Grove, ILN4043EL C Hanson Co · Helena, MTN4043GGalaxy Aviation Services LLC · Orlando, FLN4043KJackson Ian C · Rochester, NHN4043PPolar Star Corp · Kalispell, MTN40444Robinson Helicopter Co · Torrance, CAN4044DParker Helicopter LLC · Watsonville, CAN4044GFlyrs Field · Anchorage, AKN4044MRed Baron LLC · Kenai, AKN4044NLundquist Matthew Michael · Navarre, FLN4044QCloud Surfers LLC · Olathe, KSN4044ZHainline David O · Poway, CAN40451Gallego Javier · Diamond Bar, CAN40455Bluff Michael A · Lake Havasu City, AZN4045AWdw Aviation Leasing Inc · Knoxville, TNN4045DTlm Properties LLC · Gladewater, TXN4045MSchad Paul E · Gainesville, TXN4045NPrivate Flights Inc · Harleysville, PAN4045RThree Aught Seven Trucking LLC · Hyattville, WYN4045XHeikkila Delano K · Buxton, ORN4045ZEastman Gregory L · Pueblo, CON4046AN7047x-R22 LLC · Wilmington, DEN4046BWildeson Dwight L · Troutdale, ORN4046PMeyer Edward E · Bolingbrook, ILN4046ZSprik Robert Jay · Hamilton, MIN40479November Alpha LLC · Dover, DEN4047DEiff John E · Deland, FLFirst renewal noticeN4047EMission2fly LLC · Athol, IDN4047NSilverhawk Aviation Academy LLC · Caldwell, IDN4047XHarms Timothy W · Whittier, NCN4047ZGrunwaldt Peter J · Anchorage, AKN40484Sunland Air Inc · Frederick, MDN40489Classic Drywall LLC · Richmond, KYN4048MJoel Massey Real Estate LLC · Flowery Branch, GAN4048XMoorhead Equipment LLC · Belton, SC
Back to AD 2007-04-19 R1