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.
N54223Woodworth Brent J · Halliday, NDN5422BR & R Aviation LLC · Arnaudville, LAN5422DJohnson Benjamin Keith · Dayton, OHN5422QMandeville James R · Bridgewater, MAN5422SVanwagnen Brian J · Jackson, MIN5422URegistration Pending · Livermore, CORegistration pendingN54233Wenke Donald S · Big Lake, AKN5423BBeck Skydiving & Rigging LLC · Bixby, OKN5423ESkywarrior Flight Training LLC · Pensacola, FLN5423JRialto Christian Flyers Club Inc · Bradenton, FLN5423KRandel James B III · Mill Valley, CAN5423PPapp Frank J · Fort Mohave, AZN54247Registration Pending · Melbourne, FLRegistration pendingN5424AFudurich David E · Goleta, CAN5424JFusano Lisa A · La Crescenta, CAN5424PHerreid William L Jr · Prairie Du Chien, WIN5424QBeltzville Aero LLC · Lehighton, PAN5424SNeely Benson W · Florence, MSN5424UWsol Michael P DBA · Huntington Beach, CAN5424VSorbi Aviation Inc · El Cajon, CAN54251Inverted Aviation LLC · Belleair, FLN54257Meridian Airport Authority · Meridian, MSN5425AValiair Ltd Co Trustee · Casper, WYN5425BEslinger Beau T · Tucson, AZN5425LHamilton Paul DBA · Fresno, TXN5425MWong Alex · Hillsborough, CAN5425SBunn James W · New Port Richey, FLN5425WIrmen Walter Michael Jr · Arlington Heights, ILN5425YWilson Leif L · Tok, AKN5426Vieira Mark · Turlock, CAN54266Low Country Skyways LLC · Wilmington, DEN5426CVirginia Air Inc · Roanoke, VAN5426FPressley Aviation LLC · New London, NCN5426JMedia Stew LLC · Carson City, NVN5426MWorthington Aras · Anchorage, AKN5426PTromble Tim L · Story, WYN5426QLen Emery Photography LLC · Springfield, VTN54273Swanson Gary A · Fort Bragg, CAN5427BYeary Clifton K · Quitaque, TXN5427FRebel Aviation Inc · Liberty, MON5427XRegistered aircraftN54283Sale Reported · Lewistown, MTSale reportedN54285Monahan Richard J Jr · Budd Lake, NJN54288Chandler Air Service Inc · Chandler, AZN5428FSchold Maury W · Stafford Springs, CTN5428UCordova Air Service Inc · Cordova, AKN5428WBon Investment Holdings LLC · Zephyrhills, FLN54290Laguna Verde Leasing Inc · Wilmington, DEN54291Flight School Of Gwinnett Inc · Lawrenceville, GAN54296Honcho Aircraft LLC · Crosby, TX
Back to AD 2007-04-19 R1