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.
N504TBAutomotive Air III LLC · Belcamp, MDN504TMMadorin Matthew L · Mountain Green, UTN504WBLee William Perry · Jacksonville, FLN504WEArchitectural Supplements Aviation LLC · Waterbury, CTN504YBSeeker Aircraft America Inc · Albuquerque, NMN504ZSchliebe Peggy J Trustee · Scio, ORN505Lawson Jesse James · Placerville, CAN50504Baker Merlin K · Bradford, OHN50505Trombley Steven T · Worland, WYN50508Atkins Shane Alan · San Juan Capo, CAN5050GHats Off Aviation LLC · Newnan, GAN5050LFrederick Benjamin J · The Woodlands, TXN5050NRegistered aircraftN5050PBoucher Bobbi · Fredericksburg, VAN5050WLadeira Victor E · Holy Cross, AKN5051Akland Konrad R · Missoula, MTN5051DVincent Wendal J · Geismar, LAN5051EFielding John N · Scarborough, MEN5051LTarver Reuben R · Gillette, WYN5051PGrorud James R · Milbank, SDN5051QKoppikar Utpal M · Hayward, CAN5051RSkywarrior Flight Training LLC · Pensacola, FLN5051SCall Of The Loon LLC · Missoula, MTN5051TOverton Asset Group LLC · Saint Marys, IAN5051WFox Two LLC · Camino, CAN5052Tashjian Kirk G · Stanwood, WAN50523Koch Allen William · Anchorage, AKN5052DFertic Knute · Oklahoma City, OKN5052NHenning David L · Port Orange, FLN5052QSwanson Rodney Blake · Katy, TXN5052RAerial Services Inc · Wetumka, OKN5052SWonnacott Dereck · Auburn Hills, MIN5052TMatos Jonathan A · Kent, WAN5052WBray Sam · Gooding, IDN5052YCall Tracy J · Carmel Valley, CAN5053DRancho Equipment Leasing LLC · Brownsville, TXN5053EHusted Daniel C · West Decatur, PAN5053JClo Corp · Wilmington, DEN5053LHargrove Dwayne E · Shepherdsville, KYN5053NForgotten Heroes Foundation · Chesapeake, VAN5053PCc Aviation Inc · Discovery Bay, CAN5053QHoovers Truck & Equipment LLC · Dover, OHN5053SAviation Capital Management LLC · San Jose, CAN5053TSchneckenburger Kurt Partrick · Bethesda, MDN5053WJonason David · Ocean Park, WAN50545Christiansen Aviation LLC · Wilmington, DEN5054CAero Box Four LLC · Hammond, LAN5054DK&L Tech Inc · Adams, NEN5054GRobbins Warren N · Chandler, AZN5054HParker James C · Cuthbert, GA
Back to AD 2007-04-19 R1