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.
N5610SJager Rylan W · Indn Hbr Bch, FLN5610UAnderson Aviation LLC · Bulverde, TXN56114Anderson Douglas · Queen Creek, AZN56115Schenck Christopher R · The Woodlands, TXN56119Button Eric T · Austin, TXN5611JJr'S Auto Care Center Inc · Gualala, CAN5611PWeyland Aviation Inc · Lewes, DEN5611QSale Reported · Star Prairie, WISale reportedN5611SHenry Daniel · Paris, TXN56125Upstate Flying Club Inc · Marcy, NYN56126Moore Holdings LLC · Janesville, WIN56129Skurzynski James S · Santa Ana, CAN5612JNovember Aviation Corporation · Hobart, WAN5612KUptime Electonics Inc · Whittier, CAN5612PClarity Aviation LLC · Boise, IDN5612QSrm Aviation Group LLC · Bentonville, ARN56130Flying Aces Aero-Fleet Inc · Guyton, GAN56131Qualitair LLC Trustee · MichelstadtN56134Buxton Richard L · Boise, IDN56136Weed Brian Jeffrey · Omaha, NEN5613JMorgan Edward A · Buchanan Dam, TXN5613LRed Rock Flyers LLC · Flagstaff, AZN5613QLysek Eric M · Erie, CON5613UAviation Trust Company LLC Trustee · Oklahoma City, OKN5613WHocking Terry G · Nashwauk, MNN56140Lets Fly Az LLC · Scottsdale, AZN56141Simmerer Stephen J · Allenton, MIN56149Lets Fly LLC · Albemarle, NCN5614KSherwood George R · Burlington, KYN5614PShetty Balakrishna · Wesley Chapel, FLN5614QAltitude Aviation Services LLC · Mountain Home, IDN5614RLedvina Jay K · Mechanicsburg, PAN5614SShaughnessy William · Rochester, MNN5614WColeman John H · Jackson, MIN56155Blackmon Ethan T · Hot Springs, ARN56158Munyon William · Vineland, NJN5615KDennmark Air LLC · Dighton, KSN5615QKhan Awad A · Clearwater, FLN5615SBradley A Eli Dental Corp · Encinitas, CAN5615WH&H Aviation LLC · Lehi, UTN56160Thatcher Michael · Delaware, OHN56161Ohmart Jeffrey A · Wichita, KSN5616BCasey Joseph · Buffalo, WYN5616EDhl Skyhawk Inc · Martinez, CAN5616KDebonair 5616k LLC · Saco, MEN5616PKallenberger Ross A · Bakersfield, CAN5616SVanel Clyde · Cambria Heights, NYN5616YBigfoot Aviation LLC · Wilmington, DEN5617Roberts Andrew J · Brunswick, MEN5617BTruck Plus · Nampa, ID
Back to AD 2007-04-19 R1