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.
N4934SFerrell Charles A · Stockton, CAN4934USatriana Robert L · Belen, NMN49353Skye Equipment LLC · Asheboro, NCN49354Staple Three Sheep Co · Midwest, WYN49357Miller Blaine Nathan · Brooks, GAN4935AVucetic Miroslav · Coral Springs, FLN4935GKip'S Flying Service LLC · Bankston, ALN4935LCurnutt Aviation LLC · Fort Stockton, TXN4935QHaygar Berlin Inc · Shorewood, MNN49362Schubert Paul · Raleigh, NCN49363Back Country Aviation LLC · Kalispell, MTN49365Mcdonald Ryan James · Chelan, WAN49366Kellogg John H · Skaneateles, NYN4936AAnderson Dennis G · Eagle River, AKN4936LBluse James · Bethlehem, GAN4936NSwett Alan · Panora, IAN4936TDakma LLC · Parma, OHN49370Powell Weston G · Washoe Valley, NVN49371Hebert Max C · Hartstown, PAN49372Walker Scott E · Fort Collins, CON4937FRegistered aircraftN4937GInternational Air Services Inc Trustee · Carson City, NVN4937JSwirsding David J · Chalfont, PAN4937RAllred Bobby A · Centre, ALN4937SRauch James A III · Cayce, SCN4937TSalsbery Enterprises Inc · Sharpsville, INN4938AK E R Air LLC · Fort Myers, FLN4938TTilney Five LLC · Belleair, FLN4938YAerial Banners Inc · Pembroke Pines, FLN4939CBard Ralph M · Tullahoma, TNN4939LNorcross Tracy D · Saint Joseph, MON4939RMiller Farms Jv · Opheim, MTN4939SLeriche Daniel R · Wolcott, VTN4939VFlorida Keys Flight Academy LLC · Marathon, FLN4939YDavidson Dan F · Ozona, TXN493BTRegistration Pending · Deltona, FLRegistration pendingN493CAMccann James M · Ennis, MTN493CDCocozzoli Kevin A · Crestview, FLN493CKTaylor Mark Steven · Goshen, OHN493CPCivil Air Patrol · Maxwell Afb, ALN493DSDelaware State University · Dover, DEN493DWWayman Daniel M · Medford, ORN493EREmbry-Riddle Aeronautical University · Daytona Beach, FLN493FLPalmenteri Louis J · Rhome, TXN493GCClayton Neil K · Oviedo, FLFirst renewal noticeN493KPCatalano Gerry · Shingle Springs, CAN493MAGreat Planes Aviation Inc · Rochester, MNN493RMRaritan Valley Flying School · Princeton, NJN493SHForsman David G Co-Trustee · South Haven, MNN493TSoaring Concepts Inc · Sturgis, MI
Back to AD 2007-04-19 R1