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.
N52749Middle Tennessee State University · Murfreesboro, TNN5274DSimonsen Deanne M · White Salmon, WAN5274EFedermann Joe R · Anchorage, AKN5274HLincoln Skyways Inc · Lincoln, CAN5274LRetzer Daniel R · Rockford, ILN5274SHap'S Air Inc · Ames, IAN5274VH & R Aviation LLC · West Linn, ORN5274XStallings Aircraft Propeller LLC · Wynne, ARN5274YMba Sales LLC · Ridgefield, WAN52750Wieneke Robert A · Rockwall, TXN52751Weinstein Mark H · Carrollton, GAN52753Omark Aviation LLC · Naples, FLN52754Torgerson'S LLC · Ethridge, MTN52756Fowler Jon E · Cal Nev Ari, NVN52757Brady Aviation Ltd Co · Friendswood, TXN52758Luse David C · Newalla, OKN5275DWorrell Sharyl L · Anchorage, AKN5275EPasiewicz Shannon M · Anchorage, AKN5275GMccarley Kendel M · Tucson, AZN5275RNorth Matthew E · Oro Valley, AZN5275S75s Leasing LLC · Greenwood Village, CON5275VViatrans LLC · Pryor, OKN5275WMustang Sally Aviation LLC · Camden, SCN5275XKirschner David R · Mckeesport, PAN52761Reb Baron Aviation LLC · Riverdale, CAN52764Skylane LLC · Williamsburg, VAN52767Loudy William E · Rigby, IDN5276AOstermeier Brigitte · MaunNon-citizen corporation, flight hours not reportedN5276ESchmutz George L · Atascadero, CAN5276LHaynie Sidney S · Sedona, AZN5276PBellers Aviation Inc · Fremont, CAN5276VSky West Aviation Inc Trustee · Albuquerque, NMN5276WThird Step 2 LLC · Wilmington, DEFirst renewal noticeN5276XSanders Curtis E · Morrison, MON52775Pa-18 LLC · Hood River, ORN5277GRussell Michael E · Sumner, TXN5277JYr-Aircraft Leasing LLC · Bethel, AKN5277PBennett Glenn D · Kingwood, TXN5277SFers Mitchell A · Stafford Springs, CTN5277VLechner Gary D · Woodstock, ILN5277WPerkins Nathan Zachery · Bonanza, ORN52781Mckendry Martin · Carmel Valley, CAN52783Valdes Alfonso · El Paso, TXN52789Alameda Aero Club · Alameda, CAN5278DN5278d LLC · Dover, DEN5278ESeasholtz John O · Fresno, CAN5278GCostilow Bobby W · Griffin, GAN5278PRoebuck David M · Hamilton, GAN5278RHussain Mahmoud Taimour Said · Miami, FLN5278SN5278s LLC · Katy, TX
Back to AD 2007-04-19 R1