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.
N2855TMcgregor Thomas M · Chugiak, AKN28560Hemphill Thomas N · Valencia, CAN28561Carter Boys Aviation LLC · Alma, GAN28565Jenks David R · Hernando, FLN28569Harper James Barry · Cimarron, NMN2856AOne Grand Adventure LLC · De Pere, WIN2856DDunn Leslie K · Scottsdale, AZN2856HFlight School 101 LLC · Winter Haven, FLN2856KPlane Fun Inc Tr Trustee · Snellville, GAN2856PHester Alan A · Battle Ground, WAN2856QFoster Aaron J · Missoula, MTN2856RDennis Billy C Jr · Scottsdale, AZN2856TGreene Thomas M · Chapel Hill, NCN2856XHorn Paul M · Vacaville, CAN2856ZCooksey Donald R · Newcastle, WYN28572Peck Jeff · Denton, TXN28573Bearpaw Aviation LLC · Brookfield, WIN28575Maxwell Jay Nate · Cookeville, TNN2857ADusenbury Susan B · Walnut Cove, NCN2857FGarcia Gregory · Sacramento, CAN2857MCoastal Air Services LLC · Hampton, SCN2857PSale Reported · Greeley, COSale reportedN2857QM3 Aviation Florida LLC · Fort Pierce, FLN2857RWilson Gary C · Lake Tapps, WAN2857XWalton Wade · Downingtown, PAN28583Mcgee Michael R · Mamou, LAN28584Cereal City Flying Club LLC · Battle Creek, MIN2858FFlying Fur LLC · Huntsville, ALN2858HSundt Daniel N Jr Trustee · Bryn Mawr, PAN2858PSiegfried Richard W · Downers Grove, ILN2858QKelley Aircraft LLC · Weyers Cave, VAN2858RWetter Kristian · Fort Myers, FLN2858WHought Lowell T · Olathe, KSN2858ZRoberts Darren T · Vail, AZN28591Toher Wayne R · Danbury, CTN28593Mcmillan David S · Rangeley, MEN2859FValley City Flying Club Llp · Valley City, NDN2859KHuyler John G Trustee · Bellvue, CON2859QSullivan Mark F · Cocoa Beach, FLN2859TGouda Rafik M · Rancho Cucamonga, CAN2859WKoonce J Michael · Berkeley, CAN285AN285a LLC · Cincinnati, OHN285AAGoldrock Aviation LLC · Princeton, NJN285BGBowling Green Flight Center LLC · Bowling Green, OHN285BLWingsleasing LLC · Wichita, KSN285BWWatson Alex · Chadron, NEN285CSDrury'S Journey LLC · Los Altos, CAN285CVBarr Air Patrol LLC · Mesquite, TXN285DM4 Play Aviation LLC · Port Orange, FLN285DSMonmouth Area Flying Club Inc · Lakewood, NJ
Back to AD 2007-04-19 R1