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.
N5660UBecker Timothy L · Vail, AZN5660WLopez Javier Garcia · San Jose, CAN5661Bryant Billy Joe · Seymour, TNN56610Pressure Quip LLC · Houma, LAN56612Little Duane V · Puyallup, WAN56617Cherokee N56090 LLC · Jackson, GAN56619Rock Water Aviation LLC · Herriman, UTN5661BPiekarski John G · Kuna, IDN5661KShockey David Allen · Deland, FLN5661USkyventure LLC · Washington, INN56622Parts And Sparks LLC · Bunnell, FLN5662BHollibird Aviation LLC · Knightdale, NCN5662KGiddings Melvin J Jr · Vacaville, CAN5662PSullivan Anthony J · Snohomish, WAN5662QMarshall Adam S · Spokane, WAN5662UBurgin John F · Austin, TXN5662VLoft Aire Inc · Venice, FLN56637Hohenstein Douglas · Spokane, WAN56639Doskocil Mark · Winston Salem, NCFirst renewal noticeN5663NMeranda Andrew J · Morganton, NCN5663QCullen Andrew W · Tennille, GAN5663WCrane Air LLC · Waterford, MIN5663YWeltyk Michael R · Oxford, MIN56649International Air Services Inc Trustee · Carson City, NVN5664KEchols Charlotte · Wichita Falls, TXN5664YFurlong Kelly L · Athens, ALN56651Boettcher Kurt · Julian, CAN56652Carpenter Stephen K · El Paso, TXN56658American Aviation Inc · Brooksville, FLN56659Skoog Timothy Mark · Monroeville, PAN5665JFarwest Aviation LLC · Billings, MTN5665PLangevin Michael · Anchorage, AKN5665UZimmerman Damian P · Petersburg, ILN5665VWanigas Leasing Corporation · Saginaw, MIN56668Pendarvis Damon E · Morrow, OHN5666B98x LLC · Caddo Mills, TXN5666DHlavnicka Thomas L · Big Sandy, MTN5666PChrysoar Group LLC · King George, VAN56671Cooley Edward B III · Lutz, FLN56673Onward Aviation LLC · Brunswick, GAN56676Paris Air Inc · Vero Beach, FLN56679Worthington Brian M · Saint Albans, NYN5667BMarmitt Management Inc · Moses Lake, WAN5667DWilliams Field LLC · Gig Harbor, WAN5667KSmith John L · Renton, WAN5667QLove Phillip Love · Rib Mountain, WIN5667SParsons John C · Wichita, KSN5667WBartanowitz Frank · Millwood, GAN56680Sky III Corporation · Smyrna, TNN56682Hogan David · Simpsonville, SC
Back to AD 2007-04-19 R1