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.
N525GHLauff Samuel Jr · Ocala, FLN525HPPudenz Ricky A · Glidden, IAN525JBWalton Jack R · Granbury, TXN525JRPj Flyer LLC · Avondale, AZN525KGCherokee Trail Aviation LLC · Tontitown, ARN525KWFuller Thomas R · Scottsdale, AZN525LLGlasair III Investors LLC · Middleton, WIN525LRSkywalker Leasing LLC · Wilmington, DEN525MDHawaii Pacific Aviation Inc · Kailua Kona, HIN525NDAerosim Academy Inc · Sanford, FLN525PULindsay Aviation Inc · West Seneca, NYN525RRValiair Lc Trustee · Casper, WYN525SAbles Kenneth M · Taylor, AZN525SBAdams Sidney R · Belle Haven, VAN525SCM&M Flyboys LLC · Kalispell, MTN525SFPrimrose LLC · Columbus, NEN525STSkywest Leasing Inc · St George, UTN525TChomchird Jon Attaporn · Centreville, VAN525TDHigh Sky Bonanza Inc · Wilmington, DEN525TMVertivue LLC · Allentown, PAN525VBLincoln Robert D · Bedminster, NJFirst renewal noticeN525VDStefenelli Aviation N Tr Inc Trustee · AtterseeN525WTButts Bruce E · Dublin, OHN525XHarvey Thomas H · Novi, MIN52602Hutch Aviation Inc · Zavalla, TXN52606Cirrus Aviation Inc · Sarasota, FLN52607Jse Holdings Inc · Wilmington, DEN52608Kaliebe Kyle D · Mount Pleasant, WIN5260AN5260a LLC · Los Angeles, CAN5260DMeyer Kevin · Hooper, NEN5260KPacific Fleet Aviation LLC · Rochester, NYN5260NBates Management Inc · Woodstock, GAN5260RSouthern Aero LLC · Homestead, FLN5260TJordan David E · Saint Helena, CAN5260WNance James B · Terrell, TXN52617Land And Sky LLC · Buffalo, MNN5261JAc67333 Inc · Wilmington, DEN5261NCrowe Bradley Allen · North Chelmsford, MAN5261PMon-Dak Consulting Inc · Plentywood, MTFirst renewal noticeN5261UBackus Gary Carl · Chesapeake, VAN5261WHodge Nicholas C · Spokane, WAN52620High Risk Ventures Inc · San Diego, CAN52621Bottieri David P · Mission Viejo, CAN52624Shrewsbury Roy E II · Daniels, WVN52629Mbr Air LLC · Kenosha, WIN5262GDoerstling Alexander Wolfgang · Waco, TXN5262HBun Air Corp · Bedford, PAN5262LWilliams Gregory L · Tehachapi, CAN5262TSmith Gregory W · Laurel, MDN5262UL&W Aircraft Investment LLC · Homestead, FL
Back to AD 2007-04-19 R1