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.
N5338UWatermelon Packer Ll · Mcallen, TXN5338VMassie Patrick J · Friendswood, TXN53391Schwend Brian · Forsyth, MTN5339DTang Hong-Ming · San Dimas, CAN5339ENbc Investments Ltd · Granbury, TXFirst renewal noticeN5339HBering Capital LLC · Anchorage, AKN5339KNordell Kent D · Staples, MNN5339LAlpcal Group LLC · Ventura, CAN5339MM&M Management Group LLC · Englewood, CON5339SGyorke George Jr · West Ossipee, NHN5339WSmith Mark R · Pompano Beach, FLN533ACEast Tennessee Aviation Services LLC · Harrison, TNN533APHelicity Aviation LLC · Cedar Park, TXN533BMGray Ronald P · Glendale, AZN533C71sq Inc · Wilmington, DEN533CASkylink Xpress Inc · San Bernardino, CAN533CDAvem LLC · Salt Lake City, UTN533CEHoward David D · Winner, SDN533CFAircraft Guaranty Corp Trustee · Oklahoma City, OKN533FLLuvsflying Flight Training LLC · Staten Island, NYN533GRocket Ride LLC · Yakima, WAN533HTWest Wings LLC · Blair, NEN533JCWright Matthew J · Petaluma, CAN533JDButler Sam A Jr · Granbury, TXN533KAKamaka Air LLC · Honolulu, HIN533KCTidd Scott · Reading, MIN533KSKent State University · Stow, OHN533MAMercury Aviation Inc · Flowood, MSFirst renewal noticeN533MSSchlamer Mark A · Campbellsport, WIN533PMMccollom Perry C · Saint Louis, MON533SZilz Tammy S · Saint Peters, MON533SDReynolds Darryl G · Wills Point, TXN533SHCurtis Abraham · Byron, WYN533SJLns LLC · Wichita, KSN533STGentry Air LLC · Orlando, FLN533TRiser LLC · Wimberley, TXN533TDChristopher Schultheis Inc · Colton, WAN533WPJacobs Aviation LLC · Mt Juliet, TNN53402Anvab Inc DBA · Concord, NHN5340GLegal Limit Motor Sports LLC · Anderson, CAN5340LFalcon Flying Club Inc · Mesa, AZN5340MN5340m LLC · Greenville, SCN5340PDejulio Jan A · Temecula, CAN5340WHebel Ryan · North Potomac, MDN5340XAgvest LLC · Abingdon, VAN5340YCripe Michael L · San Luis Obispo, CAN53417Eastern Cincinnati Aviation Inc · Batavia, OHN5341EKatz-Braunschweig Daniel A · Staten Island, NYN5341FZhang Linjie · Peachtree City, GAN5341HHoffman Calhoun E · Barnwell, SC
Back to AD 2007-04-19 R1