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.
N39569Jayo LLC · Winston Salem, NCN3956DJohnson Justin R · Bonners Ferry, IDN3956MNew England Aviation LLC · Plainville, CTN3956PWheels Up LLC · Evansville, INN3956RSobczak Joseph E · Groveland, CAN3956XHuth William L · Gulf Breeze, FLN3956YWilliams John S · Fort Walton Beach, FLN3957ARegistration Pending · Denton, TXRegistration pendingN3957FSeipp Stephen C · Laurel, DEN3957QRwm Aviation LLC · Kalispell, MTN3957RHaushold Aviation LLC · Shelbyville, TNN3957WPorter Casey · Bluffton, SCN3957YRegistration Pending · Midland, TXRegistration pendingN3957ZAlsworth Leon R · Port Alsworth, AKN3958AHinton Richard D · Colleyville, TXN3958KArias Benjamin H · Fort Stockton, TXN3958PHoward Kevin B · Plymouth, MIN3958QFisher Gregory S · Franklin, WIN3958TPiowaty Craig M · Hilo, HIN3958ZWelstad Blaine L · Newburg, NDN3959DRandolph Clinton A · Bullhead City, AZN3959KPuertola Pascual G · Cobb, CAN3959POmaha Aircraft LLC · Blair, NEN3959RBederov Alex · Redwood City, CAN3959XCavanaugh Brian L · Manitowoc, WIN3959YRabeneau Dale · Copperopolis, CAN3959ZDld Corp · Ogden, UTN395CDSimpson Russell · Nantucket, MAN395CEBlue Bird Aviation LLC · Anchorage, AKN395CVCivil Air Patrol · Maxwell Afb, ALN395DNational Training 1 LLC · Wilmington, DEN395EUDodson Building Group LLC · Kalispell, MTN395HPGarza David Javier · Mcallen, TXN395HZPilot In Command LLC · Parker, CON395JPKane Aviation LLC · Salem, VAN395LAZapel Theodore O · Colorado Springs, CON395LMMj&J LLC · Dodge City, KSN395MAEzelle Stephen · Savannah, GAN395MTCubi Erik O · Chicopee, MAN395SAFmco Promotions Inc · North Little Rock, ARN395SPTexas State Technical College · Waco, TXN395STCm Golf LLC · Sacramento, CAN395TCAqz Aviation Inc Trustee · Wilmington, DEN395THChristiansen Aviation LLC · Wilmington, DEN395XRegistration Pending · Marion, MTRegistration pending, pending cancellationN395ZSouthern Aircraft Consultancy Inc Trustee · Casper, WYN39600Inlet Shores Aviation LLC · Ponce Inlet, FLN39609G Medical LLC · Cedar Falls, IAN3960KRegistration Pending · Roanoke, TXRegistration pendingN3960MBales Gregory W · Enterprise, OR
Back to AD 2007-04-19 R1