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.
N455QSouthern Utah University · Cedar City, UTN455RBGh Enterprises Inc · Baton Rouge, LAN455RTSouthern Genesis Aero LLC · Midland City, ALN455SDJ&L Aviation LLC · Malta, NYN455TASurles Gregory Taylor · Emerald Isle, NCN455TBSmith Loren D · Great Falls, MTN4560KRegistered aircraftN4560MPhillips William S · Normandy Park, WAFirst renewal noticeN4560PAmerican Trans Air Training Corp · Virginia Beach, VAN4560YCleveland William B III · Canal Fulton, OHN4561VOrca Wealth Management LLC · New Port Richey, FLN4561XAir Bhnb LLC · Statesboro, GAN4562FMcdaniel Dean K · Queen Creek, AZN4562MBbt Aviation LLC · Rapid City, SDN4562RMcclure Richard A · Victoria, TXN4562TSellers Kelly A · Crossville, TNN4562XVenture West LLC · Mesa, AZN4562YEd Air Inc · Oaktown, INN4563BLarose Gary R · Anchorage, AKN4563JPilling Ian M · Bonita, CAN4563SMeyerhoff Scott G Trustee · Reno, NVN4563VMercer Alexander David · San Diego, CAN4563WE&V Air LLC · Chatsworth, GAN4564FStern Aviation Inc · N Fort Myers, FLN4565AGriswold Joshua M · Wasilla, AKN4565FHughey Charles A Jr · Oak Ridge, TNN4565RHenderson Javier · Raleigh, NCN4565SGl Aviation LLC · Mcmurray, PAN4565TSchendel Daryl R · Barstow, CAN4566BWagnon Bertram L · Anchorage, AKN4566JDifilippo Antonio O · Spring Church, PAN4566MPalacios Luis A · El Paso, TXN4566RMedia Stew LLC · Carson City, NVN4566SWalters G David · Sarasota, FLN4566WBoling Kyle C · Oak Hill, FLN4566XZihala William · North Little Rock, ARN4567Amigo Helicopter Services LLC · Falfurrias, TXN45678Kdm Aviation LLC · Wilmington, DEN4567ADonovan Timothy P · Wichita Falls, TXN4567BCavu LLC · Boise, IDN4567FPatterson Roland O · Semmes, ALN4567TPhoenix East Aviation LLC · Daytona Beach, FLN4568ABartlett Michael W · Barron, WIN4568CYorde Roger C · North Fort Myers, FLN4568NBergren Scott W Trustee · Walnut Creek, CAN4568RChuss Edward J · Metamora, MIN4568SYuma Desert Fliers LLC · Yuma, AZFirst renewal noticeN4569CReese Brandon A · Bend, ORN4569HPowell Randy N Trustee · Elko, NVN4569RNoco Flying Club LLC · Fort Collins, CO
Back to AD 2007-04-19 R1