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.
N310VRWg Aircraft Holding Corp · Daytona Beach, FLN310VVMsl Air Inc · Sugar Grove, ILN310WAHbhis LLC · Gnadenhutten, OHN310WDHernandez Jr Raymond Trustee · Burleson, TXN310WGMunro Donald W · Commerce Township, MIN310WHLexington Air Services LLC · Greenwood, MSN310WJAg N310wj LLC · South Salt Lake, UTN310WKSolo Exteriors Co LLC · Seminole, TXN310WPPardue William E · Fort Worth, TXN310WSN310ws LLC · Athens, ALN310WVHill Rick A · Bridgeport, WVN310XPFour Aces Montana LLC · Missoula, MTN310XRValiair Limited Co Trustee · Casper, WYN310ZFlyin' Dog Air LLC · Niceville, FLN3110ATalon Group LLC · Marietta, GAN3110FVillalobos Isaac M · Lake Havasu City, AZN3110LYellowfin Aero LLC · Seminole, TXN3110ZLombardo Robert C · Clarks Summit, PAN3111FShaw Construction Inc · Hillsboro, OHN3111HMcniel George A · Portland, ORN3111JAir Arkansas Inc · Wilmington, DEN3111KChristiansen Aviation LLC · Wilmington, DEN3111RFetterman Robert J · Newport, MIN3111SMiller Bruce E · Lake Oswego, ORN3111USmith Skipper R · Gulfport, MSN3111WChubb Oil & Gas LLC · Missoula, MTN31121Full Flaps 2 LLC · Peachtree City, GAN3112CBagley Benjamin H · Rome, GAN3112DGrossman Steve B · Chouteau, OKN3112SKcsi Aerial Patrol Inc · Bakersfield, CAN3112UDavis James M · Tuscaloosa, ALN3112XRichards Timothy T · Sherborn, MAN3112YWykoff Donald W · West Chester, OHN3112ZSchifano Benedict S · Scottsville, NYN31133Capozzi Robert A · Greenwood, FLN31136Midwestern Helicopter LLC · Kenosha, WIN3113AN Maple LLC · Kalispell, MTN3113DWooliver Steve P · Wasilla, AKN3113GChristiansen Thad Charles · Spring Grove, ILN3113KHopf Jeffrey B · Llano, TXN3113NTorgerson Glenn Allen · Snohomish, WAN3113PCampbell Gregory · Davis, ILN3113QTj Enterprises LLC · Stayton, ORN3113RMyers Richard · Sugar Land, TXN3113UBravo Lima LLC · Tampa, FLN3113YYorkwind LLC · Gilford, NHN31143Mjj Aircraft Inc · Wilmington, DEN3114CWilkerson Bradley W · Caldwell, IDN3114LResendiz Marcelino · Alamo, TXN3114QBaird Steven L · Chapel Hill, TN
Back to AD 2007-04-19 R1