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.
N3517YRobles Serafin M · Cynthiana, KYN3517ZMeyers Carl A · Salem, CTN35183Stone Industrial Contractors Inc · Savannah, GAN35184Maliszewski William F · Independence, WIN35185Stephens Brian A · Bruceville, INN35186Mucci Eileen F · Wolcott, CTN3518BTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN3518FPortmann James R · St Louis Park, MNN3518YMcaninch Shawn R · Albia, IAFirst renewal noticeN35191West Monte D · Coldspring, TXN35192Huffman Robert V · Washington, DCN35193Mccormack Duncan M · Sunfield, MIN35196Courtney Marshall Duchesne · Mission Hills, CAN35199Global Aerials Inc · Pembroke Pines, FLN3519HGulino Thomas V · College Park, MDN3519YWeber Larry F · New Paltz, NYN3519ZSprott Robert L · Perkins, OKN351ABTropical Transport Services Ltd · San Juan, PRN351ATRegistered aircraftN351BRRosenbaum Robert · Chilmark, MAN351CACivil Air Patrol · Maxwell Afb, ALN351CPCivil Air Patrol · Maxwell Afb, ALN351GPSelby Chris A · Monticello, ARN351GSKukowski Matthew P · Wheatland, WYN351HCBig Elk Aviation LLC · Elk City, OKN351JDHillsboro Aero Academy LLC · Hillsboro, ORN351JMSeal Benjamin A · Grapevine, TXN351JPParker Robert · Oklahoma City, OKN351JSRainier Flight Service LLC · Renton, WAN351KCErickson Jason O · Mckinney, TXN351MKNorth Star Aviation · Mankato, MNN351PLifted Six Aviation LLC · Wilmington, DEN351PLBender Cliff · Plano, ILN351RRHolder Joiy R · Port Saint Lucie, FLN351RSSmith Herschel W III Md · Roswell, GAN351TBLetter Ride LLC · Woodbury, MNN351VAVictory Aviation Club Inc · Hamilton, OHN351VBWudtke Dale A Trustee · Palos Park, ILN351WHDean John · Marana, AZN351ZDofka Martin F III · Wheeling, WVN35203Sky Views Aviation LLC · Red Lodge, MTN35206Mosaic Aviation LLC · Pelham, ALN3520FWood Forrest B · Cookson, OKN3520PWidner Jack A · Stanley, NCN3520USchioppo Joseph · Boynton Beach, FLN3520WLyttle John W Jr · Chehalis, WAN3520ZWaldo Charles N · West Ossipee, NHN35211Ballester Alexis R · Mayaguez, PRN35213Aviation Adventure LLC · Munster, INN35218Chessare Gary M · Caledonia, IL
Back to AD 2007-04-19 R1