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.
N5251CSherman Randolph · Beverly Hills, CAN5251ERhinelander Flying Service Inc · Rhinelander, WIN5251HLuyster Roy A · Rochelle Park, NJN5251JNarr Craig S · Fort Mohave, AZN5251LRegistration Pending · Osage Beach, MORegistration pendingN5251NCenterline Aviation Services LLC · Huntersville, NCN5251RLong Island Aviators LLC · Seaford, NYN5251THubka Charles A · Beatrice, NEN5251UDavid Vanderpol Construction Co · Harrison, SDN5251WAir Tech Enterprise LLC · Fitzgerald, GAN5251ZMustang Sally Aviation LLC · Camden, SCN52521Rebel Aviation Inc · Liberty, MOFirst renewal noticeN52522Mustang Sally Aviation LLC · Camden, SCN52527Klingaman Tim · Gilbert, AZN5252ALong Harold M · Carson City, NVN5252DGullwing Research LLC · Willow, AKN5252JNorthwestern Michigan College · Traverse City, MIN5252KTupper Joel · Guthrie, OKN5252NKensy Ronald S · Panama City, FLN5252PBrannan Andrew · Texarkana, ARN5252SFkf LLC · Imperial, NEN5252TRunway Aviation Flight Training USA Corp · Rockwall, TXN5252WPayne Roger D · Tupelo, MSN5252XGlick Caleb A · Hillsville, VAN52531Csa Aircraft Leasing LLC · Salt Lake City, UTN52534Dedon Mark F · Dublin, CAN52535Voroshuck Clayton T · Sunnyvale, CAN52537Chico Cassandra LLC · Chico, CAN5253CMustang Sally Aviation LLC · Camden, SCN5253EWarren Clark A · Henderson, NVN5253NBlair Jonathon M · Sandpoint, IDN5253PSale Reported · Greeley, COSale reported, pending cancellationN5253RAmerican Patrols Inc · Midland, TXN5253THart William · Johnson City, TNN5253UKronauge Frank A · Dayton, OHN5253WSlipstream LLC · Cherokee, IAN5253XMaranatha Insurance Service Inc · Rancho Cucamonga, CAN52544H & H Planting Company · Duncan, MSN52546Eaton Rosemary D · Vernon, NYN5254ABuffy Aero LLC · Suwanee, GAN5254DR&R Aero Services LLC · Eden Prairie, MNN5254JWorcester Naa Flying Club · Worcester, MAN5254KStone To Glass LLC · Lake Worth, FLN5254QRocky Mountain Flight Consultants LLC · Boulder, CON5254WGlacier Peak Aviation LLC · Carnation, WAN52554Hermiston Aviation Inc · Hermiston, ORN52557Ruby James Edwin Trustee · Hereford, AZN5255ABishop Michael J · Lima, OHN5255CMcintosh Law Corp · Long Beach, CAFirst renewal noticeN5255GSetian Peter · Ennis, TX
Back to AD 2007-04-19 R1